{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Home","Identify Supply Chains","IDSC_Guidance","Identify Threats","IDT_Guidance","Identify Threat Likelihood","IDTL_Guidance","Identify Threat Consequence","IDTC_Guidance","Prioritize Risks","PR_Guidance","Mitigate Risks","MR_Guidance","Lists","Plot"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":169,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[34,3,35,11],[31,3,32,11],[1,2,1,5],[24,3,26,11],[28,3,29,11],[8,1,11,11],[13,1,13,11],[5,5,5,8],[14,1,19,11],[20,1,20,11]]}
[]
[null,null,"Companion Workbook\nManaging Climate Change Risks to Federal Agency Supply Chains"]
[null,null,"Managing Climate Change Risks to Federal Agency Supply Chains"]
[]
[]
[null,null,null,null,null,"Note: Macros must be enabled for this workbook to function properly."]
[null,"Welcome"]
[null,"Managing Climate Change Risks to Federal Agency Supply Chains"]
[null,"GSA developed a Framework for Managing Climate Change Risks to the Supply Chain to assist Federal agencies in understanding how to manage climate change risks to their mission-critical supply chains, as required under Executive Order 13653, Preparing the United States for the Impacts of Climate Change. This workbook is designed to help users step through the framework and document their findings and decisions. More information on the framework is available online at: https://sftool.gov/plan/553."]
[]
[]
[]
[null,"Workbook Contents"]
[null,"This Workbook is organized according to the framework steps:"]
[null,"●  Identify Critical Supply Chains: Document mission-critical supply chain(s)\n●  Identify Climate Change Threats: Document the climate change threats identified to have a potential impact on supply chain(s)\n●  Assess Threat Likelihood: Document the likelihood or frequency of a climate change threat impacting supply chain(s)\n●  Assess Threat Consequence: Document the magnitude of consequences if the climate change threat were to impact the supply chain(s)\n●  Prioritize Risks: Review the information entered in previous steps and prioritize the supply chains and climate change threats to address\n●  Mitigate Risks: Document climate change risk management strategies for the supply chain(s) and identify points of contact to implement strategies"]
[]
[]
[]
[]
[]
[null,"Each framework step is accompanied by a page featuring additional guidance about how to complete the step."]
[]
[null,"Workbook Elements"]
[null,"Within each of the above steps, users will find the following elements:"]
[null,null,null,"User entry cells shaded in light yellow are the only cells in this document that users can edit.  User-entered information in each step cascades throughout the rest of the tool. To edit an entry, return to the original page in which the information was entered. Note that the majority of these text boxes are fixed size. Therefore, estimated word counts for most user entry cells are provided throughout the workbook."]
[]
[]
[]
[null,null,null,"Each page in this workbook (excluding this homepage) can be exported to PDF, so that users can share their decision-making process. The \"Export to PDF\" button is in the top-right corner of each page."]
[]
[]
[null,null,null,"Each page also is accompanied by information from the Framework for Managing Climate Change Risks to the Supply Chain. Click on these buttons to find additional guidance on completing each step of the workbook."]
[]
[]
[null,null,null,"Pages that include user entry cells contain buttons to check spelling."]
[]
[]
[]
[]
[]
[]
[]
[null,"Tool Notes:"]
[null,"Developed for:",null,"U.S. General Services Administration"]
[null,"Developed by:",null,"ICF International"]
[null,"Version 2.0",null,"Developed in Excel 2013"]
[null,"August 2016"]

{"sheet":"Identify Supply Chains","index":1,"n_rows":57,"n_cols":17,"rows_kept":57,"cut":false,"hidden":false,"merged":[[13,4,16,11],[4,1,7,11],[39,4,45,11],[48,4,54,11],[57,4,63,11],[30,4,36,11],[21,4,27,11]]}
[]
[null,"Identify Critical Supply Chains"]
[]
[]
[null,"In the fields below, enter the critical supply chain(s) that you have identified. If useful, provide a description of the supply chain, including primary locations it spans, shipping modes, or other key characteristics in the Description field. To add another supply chain, click on the blue \"Add a Supply Chain\" button. To remove a supply chain, click on the red X next to the supply chain you would like to remove. Note: If you delete a supply chain using the red X button, information associated with that supply chain in this and later sections of this workbook will be removed permanently."]
[]
[]
[]
[]
[]
[]
[null,null,"Example: Data Centers"]
[]
[null,null,"Data Centers",null,"Our mission relies on dependable and fast transmission of data, as well as secure data storage. Our primary data center in the Southeastern US contains important data and data infrastructure for our continued operations. Impacts to this facility could cause serious ripple effects throughout our agency. The data center is 63,000 square feet, located along the Gulf Coast of Mississippi and near the East Pearl River."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Description of supply chain (Up to 200 words)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Description of supply chain (Up to 200 words)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Description of supply chain (Up to 200 words)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Description of supply chain (Up to 200 words)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Description of supply chain (Up to 200 words)"]

{"sheet":"IDSC_Guidance","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Identify Critical Supply Chains - Guidance"]

{"sheet":"Identify Threats","index":3,"n_rows":225,"n_cols":17,"rows_kept":225,"cut":false,"hidden":false,"merged":[[131,4,136,11],[139,4,144,11],[123,4,128,11],[14,4,16,11],[4,1,8,11],[209,4,214,11],[174,4,179,11],[182,4,187,11],[150,4,155,11],[158,4,163,11],[166,4,171,11],[217,4,222,11],[225,4,230,11],[21,4,26,11],[29,4,34,11],[37,4,42,11],[45,4,50,11],[53,4,58,11],[64,4,69,11],[72,4,77,11],[80,4,85,11],[88,4,93,11],[96,4,101,11],[107,4,112,11],[115,4,120,11],[193,4,198,11],[201,4,206,11]]}
[]
[null,"Identify Climate Change Threats"]
[]
[]
[null,"In the fields below, enter the climate change threats that you have identified. If useful, provide a description of the threat in the Notes field. To add threats to each supply chain, click on the blue \"Add a Threat\" button. To remove threats, click on the red X next to the threat you would like to remove or simply rename it as another threat. Note: If you delete a threat using the red X button, information associated with that threat in later sections of this workbook will be removed."]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Example: Data Centers"]
[null,null,"Threat Name",null,"Description"]
[null,null,"Coastal Flooding",null,"Coastal flooding events stem from sea level rise and hurricane-induced storm surge and heavy precipitation events."]
[]
[]
[]
[null,null,{"$f":"IF(SupplyChain1=\"\",\"\",SupplyChain1)","v":""},"Supply Chain 1"]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(C22,C30,C38,C46,C54,E22,E30,E38,E46,E54)","v":0},1]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SupplyChain2=\"\",\"\",SupplyChain2)","v":""},"Supply Chain 2"]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(C65,C73,C81,C89,C97,E65,E73,E81,E89,E97)","v":0},1]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SupplyChain3=\"\",\"\",SupplyChain3)","v":""},"Supply Chain 3"]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(C108,C116,C124,C132,C140,E108,E116,E124,E132,E140)","v":0},1]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SupplyChain4=\"\",\"\",SupplyChain4)","v":""},"Supply Chain 4"]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(C151,C159,C167,C175,C183,E151,E159,E167,E175,E183)","v":0},1]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SupplyChain5=\"\",\"\",SupplyChain5)","v":""},"Supply Chain 5"]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(C194,C202,C210,C218,C226,E194,E202,E210,E218,E226)","v":0},1]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Threat Name",null,"Notes (Up to 150 words)"]

{"sheet":"IDT_Guidance","index":4,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Identify Key Climate Threats - Guidance"]

{"sheet":"Identify Threat Likelihood","index":5,"n_rows":204,"n_cols":17,"rows_kept":204,"cut":false,"hidden":false,"merged":[[11,1,11,2],[11,6,13,12],[4,1,6,12],[15,2,15,3],[40,1,40,2],[26,1,26,2],[33,1,33,2],[19,6,24,12],[26,6,31,12],[33,6,38,12],[40,6,45,12],[19,1,19,2],[47,1,47,2],[47,6,52,12],[97,1,97,2],[97,6,102,12],[104,1,104,2],[104,6,109,12],[79,1,79,2],[79,6,84,12],[86,1,86,2],[86,6,91,12],[58,1,58,2],[58,6,63,12],[65,6,70,12],[72,6,77,12],[72,1,72,2],[65,1,65,2],[111,1,111,2],[111,6,116,12],[118,1,118,2],[118,6,123,12],[125,1,125,2],[125,6,130,12],[136,1,136,2],[136,6,141,12],[143,1,143,2],[143,6,148,12],[150,1,150,2],[150,6,155,12],[157,1,157,2],[157,6,162,12],[164,1,164,2],[164,6,169,12],[175,1,175,2],[175,6,180,12],[182,1,182,2],[182,6,187,12],[203,1,203,2],[203,6,208,12],[189,1,189,2],[189,6,194,12],[196,1,196,2],[196,6,201,12]]}
[]
[null,"Assess Likelihood of Climate Change Threat"]
[]
[]
[null,"Document the likelihood of the climate change threats that you have identified in the drop-down fields below. If needed, provide a description of the threat frequency in the Notes field."]
[]
[]
[]
[]
[null,null,null,null,"Example: Data Centers"]
[null,"Threat",null,null,"Likelihood",null,"Notes (e.g., How frequently is the supply chain impacted by the climate change threat?"]
[null,"Coastal Flooding",null,null,"Moderate",null,"The data center is at risk for increased coastal flooding and impacts of sea level rise because of its coastal location. Sea level rise, in concert with storm surge events, may increase the intensity of flooding in the area of the data center, putting equipment at risk for damage. Hurricanes that have affected data center operations in recent history include Betsy in 1965, Camille in 1969, and Katrina in 2005. Between 1924-2009, sea levels have risen by 0.9 inches per decade, on average. Sea levels are projected to rise 2-4 inches by the 2020's, 6-10 inches by the 2050's, and 11-19 inches by the 2080's, greatly increasing the future risk of coastal flooding in this area."]
[]
[]
[]
[null,null,"Supply Chain 1",null,{"$f":"IF(SupplyChain1=\"\",\"\",SupplyChain1)","v":""}]
[]
[null,"Threat",null,null,"Likelihood",null,"Notes (e.g., How frequently is the supply chain impacted by the climate change threat? Up to 175 words)"]
[]
[null,{"$f":"IF(SC1_T1=0,\"\",SC1_T1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(E20:M53)","v":0}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC1_T2=0,\"\",SC1_T2)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC1_T3=0,\"\",SC1_T3)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC1_T4=0,\"\",SC1_T4)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC1_T5=0,\"\",SC1_T5)","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,"Supply Chain 2",null,{"$f":"IF(SupplyChain2=\"\",\"\",SupplyChain2)","v":""}]
[]
[null,"Threat",null,null,"Likelihood",null,"Notes (e.g., How frequently is the supply chain impacted by the climate change threat? Up to 175 words)"]
[]
[null,{"$f":"IF(SC2_T1=0,\"\",SC2_T1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(E59:M92)","v":0}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC2_T2=0,\"\",SC2_T2)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC2_T3=0,\"\",SC2_T3)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC2_T4=0,\"\",SC2_T4)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC2_T5=0,\"\",SC2_T5)","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,"Supply Chain 3",null,{"$f":"IF(SupplyChain3=\"\",\"\",SupplyChain3)","v":""}]
[]
[null,"Threat",null,null,"Likelihood",null,"Notes (e.g., How frequently is the supply chain impacted by the climate change threat? Up to 175 words)"]
[]
[null,{"$f":"IF(SC3_T1=0,\"\",SC3_T1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(E98:M131)","v":0}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC3_T2=0,\"\",SC3_T2)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC3_T3=0,\"\",SC3_T3)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC3_T4=0,\"\",SC3_T4)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC3_T5=0,\"\",SC3_T5)","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,"Supply Chain 4",null,{"$f":"IF(SupplyChain4=\"\",\"\",SupplyChain4)","v":""}]
[]
[null,"Threat",null,null,"Likelihood",null,"Notes (e.g., How frequently is the supply chain impacted by the climate change threat? Up to 175 words)"]
[]
[null,{"$f":"IF(SC4_T1=0,\"\",SC4_T1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(E137:M170)","v":0}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC4_T2=0,\"\",SC4_T2)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC4_T3=0,\"\",SC4_T3)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC4_T4=0,\"\",SC4_T4)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC4_T5=0,\"\",SC4_T5)","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,"Supply Chain 5",null,{"$f":"IF(SupplyChain5=\"\",\"\",SupplyChain5)","v":""}]
[]
[null,"Threat",null,null,"Likelihood",null,"Notes (e.g., How frequently is the supply chain impacted by the climate change threat? Up to 175 words)"]
[]
[null,{"$f":"IF(SC5_T1=0,\"\",SC5_T1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(E176:M209)","v":0}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC5_T2=0,\"\",SC5_T2)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC5_T3=0,\"\",SC5_T3)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC5_T4=0,\"\",SC5_T4)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC5_T5=0,\"\",SC5_T5)","v":""}]

{"sheet":"IDTL_Guidance","index":6,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Assess Likelihood of Climate Change Threat - Guidance"]

{"sheet":"Identify Threat Consequence","index":7,"n_rows":204,"n_cols":16,"rows_kept":204,"cut":false,"hidden":false,"merged":[[47,6,52,12],[9,4,9,5],[11,1,11,2],[11,6,13,12],[26,1,26,2],[33,1,33,2],[40,1,40,2],[19,6,24,12],[26,6,31,12],[33,6,38,12],[40,6,45,12],[9,2,9,3],[79,1,79,2],[86,1,86,2],[79,6,84,12],[86,6,91,12],[58,6,63,12],[65,6,70,12],[72,6,77,12],[72,1,72,2],[58,1,58,2],[65,1,65,2],[54,4,54,5],[47,1,47,2],[15,2,15,3],[15,4,15,5],[19,1,19,2],[93,4,93,5],[97,1,97,2],[104,1,104,2],[97,6,102,12],[104,6,109,12],[125,6,130,12],[136,6,141,12],[143,1,143,2],[111,1,111,2],[118,1,118,2],[111,6,116,12],[118,6,123,12],[125,1,125,2],[164,1,164,2],[157,6,162,12],[164,6,169,12],[132,4,132,5],[136,1,136,2],[4,1,7,12],[203,1,203,2],[189,1,189,2],[196,1,196,2],[189,6,194,12],[196,6,201,12],[203,6,208,12],[171,4,171,5],[175,1,175,2],[182,1,182,2],[175,6,180,12],[182,6,187,12],[150,1,150,2],[143,6,148,12],[150,6,155,12],[157,1,157,2]]}
[]
[null,"Assess Magnitude of Consequences of Threats"]
[]
[]
[null,"Document the magnitude of consequence of the threats that you have identified in the drop-down fields below. If needed, provide a description of the threat's impacts in the Notes field."]
[]
[]
[]
[]
[null,null,null,null,"Example: Data Centers"]
[null,"Threat",null,null,"Consequence",null,"Notes (e.g., How severe are the impacts to your supply chain?)"]
[null,"Coastal Flooding",null,null,"Major",null,"Riverine flooding, increased intensity of storms, and sea level rise could result in flooding and corrosion of coastal infrastructure (due to contact with water, especially salt water). Flooding may also diminish the availability of resources or manufacturing capability, which could make it difficult for the data center to access certain supplies. Coastal flooding can also create broader impacts to coastal infrastructure upon which it relies, such as energy systems (though the data center has generators onsite), wastewater treatment, and storm water management systems. Any significant disruptions to these systems would pose serious negative implications for the data center."]
[]
[]
[]
[null,null,"Supply Chain 1",null,{"$f":"IF('Identify Supply Chains'!$C$22=\"\",\"\",'Identify Supply Chains'!$C$22)","v":""}]
[]
[null,"Threat",null,null,"Consequence",null,"Notes (e.g., How severe are the impacts to your supply chain? Up to 175 words)"]
[]
[null,{"$f":"IF(SC1_T1=0,\"\",SC1_T1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(E20:M53)","v":0}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC1_T2=0,\"\",SC1_T2)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC1_T3=0,\"\",SC1_T3)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC1_T4=0,\"\",SC1_T4)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC1_T5=0,\"\",SC1_T5)","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,"Supply Chain 2",null,{"$f":"IF('Identify Supply Chains'!$C$31=\"\",\"\",'Identify Supply Chains'!$C$31)","v":""}]
[]
[null,"Threat",null,null,"Consequence",null,"Notes (e.g., How severe are the impacts to your supply chain? Up to 175 words)"]
[]
[null,{"$f":"IF(SC2_T1=0,\"\",SC2_T1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(E59:M92)","v":0}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC2_T2=0,\"\",SC2_T2)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC2_T3=0,\"\",SC2_T3)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC2_T4=0,\"\",SC2_T4)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC2_T5=0,\"\",SC2_T5)","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,"Supply Chain 3",null,{"$f":"IF(SupplyChain3=\"\",\"\",SupplyChain3)","v":""}]
[]
[null,"Threat",null,null,"Consequence",null,"Notes (e.g., How severe are the impacts to your supply chain? Up to 175 words)"]
[]
[null,{"$f":"IF(SC3_T1=0,\"\",SC3_T1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(E98:M131)","v":0}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC3_T2=0,\"\",SC3_T2)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC3_T3=0,\"\",SC3_T3)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC3_T4=0,\"\",SC3_T4)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC3_T5=0,\"\",SC3_T5)","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,"Supply Chain 4",null,{"$f":"IF(SupplyChain4=\"\",\"\",SupplyChain4)","v":""}]
[]
[null,"Threat",null,null,"Consequence",null,"Notes (e.g., How severe are the impacts to your supply chain? Up to 175 words)"]
[]
[null,{"$f":"IF(SC4_T1=0,\"\",SC4_T1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(E137:M170)","v":0}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC4_T2=0,\"\",SC4_T2)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC4_T3=0,\"\",SC4_T3)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC4_T4=0,\"\",SC4_T4)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC4_T5=0,\"\",SC4_T5)","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,"Supply Chain 5",null,{"$f":"IF(SupplyChain5=\"\",\"\",SupplyChain5)","v":""}]
[]
[null,"Threat",null,null,"Consequence",null,"Notes (e.g., How severe are the impacts to your supply chain? Up to 175 words)"]
[]
[null,{"$f":"IF(SC5_T1=0,\"\",SC5_T1)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(E176:M209)","v":0}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC5_T2=0,\"\",SC5_T2)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC5_T3=0,\"\",SC5_T3)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC5_T4=0,\"\",SC5_T4)","v":""}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SC5_T5=0,\"\",SC5_T5)","v":""}]

{"sheet":"IDTC_Guidance","index":8,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,1,5,6],[6,1,6,4],[7,1,7,4],[8,1,8,4]]}
[]
[null,"Assess Magnitude of Consequences of Threats - Guidance"]
[]
[]
[null,"Table of Contents"]
[null,"Assessing the Consequences of Climate Change Threats"]
[null,"Rating Consequence Magnitude"]
[null,"Self-Assessment Questionnaire"]
[null,"Workshop Scenario Planning"]

{"sheet":"Prioritize Risks","index":9,"n_rows":433,"n_cols":28,"rows_kept":433,"cut":false,"hidden":false,"merged":[[127,3,127,22],[50,3,54,22],[129,3,133,22],[26,3,26,17],[38,3,38,23],[41,3,41,15],[41,17,41,22],[42,3,44,15],[42,17,44,22],[48,3,48,22],[432,3,439,15],[432,17,439,22],[431,3,431,15],[401,17,401,22],[402,3,409,15],[402,17,409,22],[416,17,416,22],[337,17,337,22],[338,3,345,15],[338,17,345,22],[337,3,337,15],[401,3,401,15],[416,3,416,15],[352,3,352,15],[371,3,371,15],[371,17,371,22],[364,3,364,22],[372,17,379,22],[386,17,386,22],[387,3,394,15],[387,17,394,22],[386,3,386,15],[352,17,352,22],[353,3,360,15],[274,3,281,15],[274,17,281,22],[292,17,292,22],[293,3,300,15],[293,17,300,22],[307,3,307,15],[322,3,322,15],[285,3,285,22],[213,3,213,15],[130,2,134,2],[353,17,360,22],[243,17,243,22],[244,3,251,15],[244,17,251,22],[101,3,108,15],[101,17,108,22],[115,17,115,22],[116,3,123,15],[116,17,123,22],[194,17,194,22],[195,3,202,15],[195,17,202,22],[144,3,148,22],[134,17,134,22],[135,3,142,15],[135,17,142,22],[134,3,134,15],[206,3,206,22],[323,3,330,15],[323,17,330,22],[258,17,258,22],[259,3,266,15],[259,17,266,22],[51,2,55,2],[65,3,69,22],[66,2,70,2],[80,3,84,22],[81,2,85,2],[95,3,99,22],[96,2,100,2],[110,3,114,22],[111,2,115,2],[115,3,115,15],[55,17,55,22],[70,17,70,22],[71,3,78,15],[71,17,78,22],[56,3,63,15],[55,3,55,15],[86,3,93,15],[86,17,93,22],[100,17,100,22],[85,3,85,15],[100,3,100,15],[85,17,85,22],[56,17,63,22],[70,3,70,15],[145,2,149,2],[159,3,163,22],[160,2,164,2],[174,3,178,22],[175,2,179,2],[189,3,193,22],[190,2,194,2],[149,17,149,22],[150,3,157,15],[150,17,157,22],[164,17,164,22],[149,3,149,15],[164,3,164,15],[165,3,172,15],[165,17,172,22],[179,17,179,22],[180,3,187,15],[194,3,194,15],[180,17,187,22],[179,3,179,15],[209,2,213,2],[223,3,227,22],[224,2,228,2],[238,3,242,22],[239,2,243,2],[253,3,257,22],[254,2,258,2],[268,3,272,22],[269,2,273,2],[214,17,221,22],[243,3,243,15],[258,3,258,15],[228,17,228,22],[229,3,236,15],[229,17,236,22],[228,3,228,15],[213,17,213,22],[214,3,221,15],[273,17,273,22],[273,3,273,15],[208,3,212,22],[288,2,292,2],[302,3,306,22],[303,2,307,2],[317,3,321,22],[318,2,322,2],[332,3,336,22],[333,2,337,2],[347,3,351,22],[348,2,352,2],[292,3,292,15],[287,3,291,22],[307,17,307,22],[308,3,315,15],[308,17,315,22],[322,17,322,22],[366,3,370,22],[367,2,371,2],[381,3,385,22],[382,2,386,2],[396,3,400,22],[397,2,401,2],[411,3,415,22],[412,2,416,2],[426,3,430,22],[427,2,431,2],[431,17,431,22],[372,3,379,15],[417,3,424,15],[417,17,424,22],[3,1,6,23],[25,3,25,5],[25,6,25,8],[25,9,25,11],[25,12,25,14],[25,15,25,17],[22,2,24,2],[19,2,21,2],[16,2,18,2],[13,2,15,2],[10,2,12,2],[10,1,24,1]]}
[]
[null,"Review Results and Prioritize Risks"]
[]
[null,"This page summarizes the climate change risks you have identified and suggests priority risks and supply chains that may warrant development of risk management strategies. The chart below illustrates the intersection between each climate change threat's likelihood of occurrence and consequence of impact. Colors of shapes correspond to each supply chain, and shapes correspond to each climate change threat (Threat 1, 2, 3, etc.). Users should only consider the quadrant in which each climate change threat is located, rather than its relative position within the quadrant. Also, while the risk map is informative, it is not an exact science, does not capture all the elements of risk, and should not be the only approach to identify priority risks. Select the button below to see further guidance."]
[]
[]
[]
[]
[]
[]
[null,"Likelihood of Occurrence","Very High",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Risk Level",null,"Threat","Supply Chain",null,"SC#"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C40=\"\",\"\",IF(Lists!$H40=\"No entry\",\"\",Lists!$H40&\" Risk\"))","v":""},{"$f":"IF(Lists!$H40=\"No entry\",\"\",Lists!$F40)","v":""},{"$f":"IF(Lists!$C40=\"\",\"\",IF(Lists!$H40=\"No entry\",\"\",Lists!$C40))","v":""},{"$f":"IF(Lists!$D40=\"\",\"\",IF(Lists!$H40=\"No entry\",\"\",Lists!$D40))","v":""},null,{"$f":"IF(Lists!$D40=\"\",\"\",IF(Lists!$H40=\"No entry\",\"\",Lists!$G40))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C41=\"\",\"\",IF(Lists!$H41=\"No entry\",\"\",Lists!$H41&\" Risk\"))","v":""},{"$f":"IF(Lists!$H41=\"No entry\",\"\",Lists!$F41)","v":""},{"$f":"IF(Lists!$C41=\"\",\"\",IF(Lists!$H41=\"No entry\",\"\",Lists!$C41))","v":""},{"$f":"IF(Lists!$D41=\"\",\"\",IF(Lists!$H41=\"No entry\",\"\",Lists!$D41))","v":""},null,{"$f":"IF(Lists!$D41=\"\",\"\",IF(Lists!$H41=\"No entry\",\"\",Lists!$G41))","v":""}]
[null,null,"High",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C42=\"\",\"\",IF(Lists!$H42=\"No entry\",\"\",Lists!$H42&\" Risk\"))","v":""},{"$f":"IF(Lists!$H42=\"No entry\",\"\",Lists!$F42)","v":""},{"$f":"IF(Lists!$C42=\"\",\"\",IF(Lists!$H42=\"No entry\",\"\",Lists!$C42))","v":""},{"$f":"IF(Lists!$D42=\"\",\"\",IF(Lists!$H42=\"No entry\",\"\",Lists!$D42))","v":""},null,{"$f":"IF(Lists!$D42=\"\",\"\",IF(Lists!$H42=\"No entry\",\"\",Lists!$G42))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C43=\"\",\"\",IF(Lists!$H43=\"No entry\",\"\",Lists!$H43&\" Risk\"))","v":""},{"$f":"IF(Lists!$H43=\"No entry\",\"\",Lists!$F43)","v":""},{"$f":"IF(Lists!$C43=\"\",\"\",IF(Lists!$H43=\"No entry\",\"\",Lists!$C43))","v":""},{"$f":"IF(Lists!$D43=\"\",\"\",IF(Lists!$H43=\"No entry\",\"\",Lists!$D43))","v":""},null,{"$f":"IF(Lists!$D43=\"\",\"\",IF(Lists!$H43=\"No entry\",\"\",Lists!$G43))","v":""}]
[null,null,"Medium",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C44=\"\",\"\",IF(Lists!$H44=\"No entry\",\"\",Lists!$H44&\" Risk\"))","v":""},{"$f":"IF(Lists!$H44=\"No entry\",\"\",Lists!$F44)","v":""},{"$f":"IF(Lists!$C44=\"\",\"\",IF(Lists!$H44=\"No entry\",\"\",Lists!$C44))","v":""},{"$f":"IF(Lists!$D44=\"\",\"\",IF(Lists!$H44=\"No entry\",\"\",Lists!$D44))","v":""},null,{"$f":"IF(Lists!$D44=\"\",\"\",IF(Lists!$H44=\"No entry\",\"\",Lists!$G44))","v":""}]
[null,null,"Moderate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C45=\"\",\"\",IF(Lists!$H45=\"No entry\",\"\",Lists!$H45&\" Risk\"))","v":""},{"$f":"IF(Lists!$H45=\"No entry\",\"\",Lists!$F45)","v":""},{"$f":"IF(Lists!$C45=\"\",\"\",IF(Lists!$H45=\"No entry\",\"\",Lists!$C45))","v":""},{"$f":"IF(Lists!$D45=\"\",\"\",IF(Lists!$H45=\"No entry\",\"\",Lists!$D45))","v":""},null,{"$f":"IF(Lists!$D45=\"\",\"\",IF(Lists!$H45=\"No entry\",\"\",Lists!$G45))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C46=\"\",\"\",IF(Lists!$H46=\"No entry\",\"\",Lists!$H46&\" Risk\"))","v":""},{"$f":"IF(Lists!$H46=\"No entry\",\"\",Lists!$F46)","v":""},{"$f":"IF(Lists!$C46=\"\",\"\",IF(Lists!$H46=\"No entry\",\"\",Lists!$C46))","v":""},{"$f":"IF(Lists!$D46=\"\",\"\",IF(Lists!$H46=\"No entry\",\"\",Lists!$D46))","v":""},null,{"$f":"IF(Lists!$D46=\"\",\"\",IF(Lists!$H46=\"No entry\",\"\",Lists!$G46))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C47=\"\",\"\",IF(Lists!$H47=\"No entry\",\"\",Lists!$H47&\" Risk\"))","v":""},{"$f":"IF(Lists!$H47=\"No entry\",\"\",Lists!$F47)","v":""},{"$f":"IF(Lists!$C47=\"\",\"\",IF(Lists!$H47=\"No entry\",\"\",Lists!$C47))","v":""},{"$f":"IF(Lists!$D47=\"\",\"\",IF(Lists!$H47=\"No entry\",\"\",Lists!$D47))","v":""},null,{"$f":"IF(Lists!$D47=\"\",\"\",IF(Lists!$H47=\"No entry\",\"\",Lists!$G47))","v":""}]
[null,null,"Low",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C48=\"\",\"\",IF(Lists!$H48=\"No entry\",\"\",Lists!$H48&\" Risk\"))","v":""},{"$f":"IF(Lists!$H48=\"No entry\",\"\",Lists!$F48)","v":""},{"$f":"IF(Lists!$C48=\"\",\"\",IF(Lists!$H48=\"No entry\",\"\",Lists!$C48))","v":""},{"$f":"IF(Lists!$D48=\"\",\"\",IF(Lists!$H48=\"No entry\",\"\",Lists!$D48))","v":""},null,{"$f":"IF(Lists!$D48=\"\",\"\",IF(Lists!$H48=\"No entry\",\"\",Lists!$G48))","v":""}]
[null,null,"Low",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C49=\"\",\"\",IF(Lists!$H49=\"No entry\",\"\",Lists!$H49&\" Risk\"))","v":""},{"$f":"IF(Lists!$H49=\"No entry\",\"\",Lists!$F49)","v":""},{"$f":"IF(Lists!$C49=\"\",\"\",IF(Lists!$H49=\"No entry\",\"\",Lists!$C49))","v":""},{"$f":"IF(Lists!$D49=\"\",\"\",IF(Lists!$H49=\"No entry\",\"\",Lists!$D49))","v":""},null,{"$f":"IF(Lists!$D49=\"\",\"\",IF(Lists!$H49=\"No entry\",\"\",Lists!$G49))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C50=\"\",\"\",IF(Lists!$H50=\"No entry\",\"\",Lists!$H50&\" Risk\"))","v":""},{"$f":"IF(Lists!$H50=\"No entry\",\"\",Lists!$F50)","v":""},{"$f":"IF(Lists!$C50=\"\",\"\",IF(Lists!$H50=\"No entry\",\"\",Lists!$C50))","v":""},{"$f":"IF(Lists!$D50=\"\",\"\",IF(Lists!$H50=\"No entry\",\"\",Lists!$D50))","v":""},null,{"$f":"IF(Lists!$D50=\"\",\"\",IF(Lists!$H50=\"No entry\",\"\",Lists!$G50))","v":""}]
[null,null,"Very Low",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C51=\"\",\"\",IF(Lists!$H51=\"No entry\",\"\",Lists!$H51&\" Risk\"))","v":""},{"$f":"IF(Lists!$H51=\"No entry\",\"\",Lists!$F51)","v":""},{"$f":"IF(Lists!$C51=\"\",\"\",IF(Lists!$H51=\"No entry\",\"\",Lists!$C51))","v":""},{"$f":"IF(Lists!$D51=\"\",\"\",IF(Lists!$H51=\"No entry\",\"\",Lists!$D51))","v":""},null,{"$f":"IF(Lists!$D51=\"\",\"\",IF(Lists!$H51=\"No entry\",\"\",Lists!$G51))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C52=\"\",\"\",IF(Lists!$H52=\"No entry\",\"\",Lists!$H52&\" Risk\"))","v":""},{"$f":"IF(Lists!$H52=\"No entry\",\"\",Lists!$F52)","v":""},{"$f":"IF(Lists!$C52=\"\",\"\",IF(Lists!$H52=\"No entry\",\"\",Lists!$C52))","v":""},{"$f":"IF(Lists!$D52=\"\",\"\",IF(Lists!$H52=\"No entry\",\"\",Lists!$D52))","v":""},null,{"$f":"IF(Lists!$D52=\"\",\"\",IF(Lists!$H52=\"No entry\",\"\",Lists!$G52))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C53=\"\",\"\",IF(Lists!$H53=\"No entry\",\"\",Lists!$H53&\" Risk\"))","v":""},{"$f":"IF(Lists!$H53=\"No entry\",\"\",Lists!$F53)","v":""},{"$f":"IF(Lists!$C53=\"\",\"\",IF(Lists!$H53=\"No entry\",\"\",Lists!$C53))","v":""},{"$f":"IF(Lists!$D53=\"\",\"\",IF(Lists!$H53=\"No entry\",\"\",Lists!$D53))","v":""},null,{"$f":"IF(Lists!$D53=\"\",\"\",IF(Lists!$H53=\"No entry\",\"\",Lists!$G53))","v":""}]
[null,null,null,"Insignificant",null,null,"Minor","Low",null,"Moderate",null,"Medium","Major",null,null,"Catastrophic",null,null,null,{"$f":"IF(Lists!$C54=\"\",\"\",IF(Lists!$H54=\"No entry\",\"\",Lists!$H54&\" Risk\"))","v":""},{"$f":"IF(Lists!$H54=\"No entry\",\"\",Lists!$F54)","v":""},{"$f":"IF(Lists!$C54=\"\",\"\",IF(Lists!$H54=\"No entry\",\"\",Lists!$C54))","v":""},{"$f":"IF(Lists!$D54=\"\",\"\",IF(Lists!$H54=\"No entry\",\"\",Lists!$D54))","v":""},null,{"$f":"IF(Lists!$D54=\"\",\"\",IF(Lists!$H54=\"No entry\",\"\",Lists!$G54))","v":""}]
[null,null,null,"Consequence of Impact",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C55=\"\",\"\",IF(Lists!$H55=\"No entry\",\"\",Lists!$H55&\" Risk\"))","v":""},{"$f":"IF(Lists!$H55=\"No entry\",\"\",Lists!$F55)","v":""},{"$f":"IF(Lists!$C55=\"\",\"\",IF(Lists!$H55=\"No entry\",\"\",Lists!$C55))","v":""},{"$f":"IF(Lists!$D55=\"\",\"\",IF(Lists!$H55=\"No entry\",\"\",Lists!$D55))","v":""},null,{"$f":"IF(Lists!$D55=\"\",\"\",IF(Lists!$H55=\"No entry\",\"\",Lists!$G55))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C56=\"\",\"\",IF(Lists!$H56=\"No entry\",\"\",Lists!$H56&\" Risk\"))","v":""},{"$f":"IF(Lists!$H56=\"No entry\",\"\",Lists!$F56)","v":""},{"$f":"IF(Lists!$C56=\"\",\"\",IF(Lists!$H56=\"No entry\",\"\",Lists!$C56))","v":""},{"$f":"IF(Lists!$D56=\"\",\"\",IF(Lists!$H56=\"No entry\",\"\",Lists!$D56))","v":""},null,{"$f":"IF(Lists!$D56=\"\",\"\",IF(Lists!$H56=\"No entry\",\"\",Lists!$G56))","v":""}]
[null,null,null,"Legend",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C57=\"\",\"\",IF(Lists!$H57=\"No entry\",\"\",Lists!$H57&\" Risk\"))","v":""},{"$f":"IF(Lists!$H57=\"No entry\",\"\",Lists!$F57)","v":""},{"$f":"IF(Lists!$C57=\"\",\"\",IF(Lists!$H57=\"No entry\",\"\",Lists!$C57))","v":""},{"$f":"IF(Lists!$D57=\"\",\"\",IF(Lists!$H57=\"No entry\",\"\",Lists!$D57))","v":""},null,{"$f":"IF(Lists!$D57=\"\",\"\",IF(Lists!$H57=\"No entry\",\"\",Lists!$G57))","v":""}]
[null,null,null,"Risk",null,null,null,"Icons",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lists!$C58=\"\",\"\",IF(Lists!$H58=\"No entry\",\"\",Lists!$H58&\" Risk\"))","v":""},{"$f":"IF(Lists!$H58=\"No entry\",\"\",Lists!$F58)","v":""},{"$f":"IF(Lists!$C58=\"\",\"\",IF(Lists!$H58=\"No entry\",\"\",Lists!$C58))","v":""},{"$f":"IF(Lists!$D58=\"\",\"\",IF(Lists!$H58=\"No entry\",\"\",Lists!$D58))","v":""},null,{"$f":"IF(Lists!$D58=\"\",\"\",IF(Lists!$H58=\"No entry\",\"\",Lists!$G58))","v":""}]
[null,null,null,null,null,null,null,"Supply Chain/Color",null,null,null,null,"Threat/Symbol",null,null,null,null,null,null,{"$f":"IF(Lists!$C59=\"\",\"\",IF(Lists!$H59=\"No entry\",\"\",Lists!$H59&\" Risk\"))","v":""},{"$f":"IF(Lists!$H59=\"No entry\",\"\",Lists!$F59)","v":""},{"$f":"IF(Lists!$C59=\"\",\"\",IF(Lists!$H59=\"No entry\",\"\",Lists!$C59))","v":""},{"$f":"IF(Lists!$D59=\"\",\"\",IF(Lists!$H59=\"No entry\",\"\",Lists!$D59))","v":""},null,{"$f":"IF(Lists!$D59=\"\",\"\",IF(Lists!$H59=\"No entry\",\"\",Lists!$G59))","v":""}]
[null,null,null,"Extreme Risk",null,null,null,{"$f":"IF(SupplyChain1=\"\",\"\",SupplyChain1)","v":""},null,null,null,null,"Threat 1",null,null,null,null,null,null,{"$f":"IF(Lists!$C60=\"\",\"\",IF(Lists!$H60=\"No entry\",\"\",Lists!$H60&\" Risk\"))","v":""},{"$f":"IF(Lists!$H60=\"No entry\",\"\",Lists!$F60)","v":""},{"$f":"IF(Lists!$C60=\"\",\"\",IF(Lists!$H60=\"No entry\",\"\",Lists!$C60))","v":""},{"$f":"IF(Lists!$D60=\"\",\"\",IF(Lists!$H60=\"No entry\",\"\",Lists!$D60))","v":""},null,{"$f":"IF(Lists!$D60=\"\",\"\",IF(Lists!$H60=\"No entry\",\"\",Lists!$G60))","v":""}]
[null,null,null,"High Risk",null,null,null,{"$f":"IF(SupplyChain2=\"\",\"\",SupplyChain2)","v":""},null,null,null,null,"Threat 2",null,null,null,null,null,null,{"$f":"IF(Lists!$C61=\"\",\"\",IF(Lists!$H61=\"No entry\",\"\",Lists!$H61&\" Risk\"))","v":""},{"$f":"IF(Lists!$H61=\"No entry\",\"\",Lists!$F61)","v":""},{"$f":"IF(Lists!$C61=\"\",\"\",IF(Lists!$H61=\"No entry\",\"\",Lists!$C61))","v":""},{"$f":"IF(Lists!$D61=\"\",\"\",IF(Lists!$H61=\"No entry\",\"\",Lists!$D61))","v":""},null,{"$f":"IF(Lists!$D61=\"\",\"\",IF(Lists!$H61=\"No entry\",\"\",Lists!$G61))","v":""}]
[null,null,null,"Medium Risk",null,null,null,{"$f":"IF(SupplyChain3=\"\",\"\",SupplyChain3)","v":""},null,null,null,null,"Threat 3",null,null,null,null,null,null,{"$f":"IF(Lists!$C62=\"\",\"\",IF(Lists!$H62=\"No entry\",\"\",Lists!$H62&\" Risk\"))","v":""},{"$f":"IF(Lists!$H62=\"No entry\",\"\",Lists!$F62)","v":""},{"$f":"IF(Lists!$C62=\"\",\"\",IF(Lists!$H62=\"No entry\",\"\",Lists!$C62))","v":""},{"$f":"IF(Lists!$D62=\"\",\"\",IF(Lists!$H62=\"No entry\",\"\",Lists!$D62))","v":""},null,{"$f":"IF(Lists!$D62=\"\",\"\",IF(Lists!$H62=\"No entry\",\"\",Lists!$G62))","v":""}]
[null,null,null,"Low Risk",null,null,null,{"$f":"IF(SupplyChain4=\"\",\"\",SupplyChain4)","v":""},null,null,null,null,"Threat 4",null,null,null,null,null,null,{"$f":"IF(Lists!$C63=\"\",\"\",IF(Lists!$H63=\"No entry\",\"\",Lists!$H63&\" Risk\"))","v":""},{"$f":"IF(Lists!$H63=\"No entry\",\"\",Lists!$F63)","v":""},{"$f":"IF(Lists!$C63=\"\",\"\",IF(Lists!$H63=\"No entry\",\"\",Lists!$C63))","v":""},{"$f":"IF(Lists!$D63=\"\",\"\",IF(Lists!$H63=\"No entry\",\"\",Lists!$D63))","v":""},null,{"$f":"IF(Lists!$D63=\"\",\"\",IF(Lists!$H63=\"No entry\",\"\",Lists!$G63))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(SupplyChain5=\"\",\"\",SupplyChain5)","v":""},null,null,null,null,"Threat 5",null,null,null,null,null,null,{"$f":"IF(Lists!$C64=\"\",\"\",IF(Lists!$H64=\"No entry\",\"\",Lists!$H64&\" Risk\"))","v":""},{"$f":"IF(Lists!$H64=\"No entry\",\"\",Lists!$F64)","v":""},{"$f":"IF(Lists!$C64=\"\",\"\",IF(Lists!$H64=\"No entry\",\"\",Lists!$C64))","v":""},{"$f":"IF(Lists!$D64=\"\",\"\",IF(Lists!$H64=\"No entry\",\"\",Lists!$D64))","v":""},null,{"$f":"IF(Lists!$D64=\"\",\"\",IF(Lists!$H64=\"No entry\",\"\",Lists!$G64))","v":""}]
[]
[null,null,"Example: Data Centers"]
[null,null,null,"Coastal flooding events stem from sea level rise and hurricane-induced storm surge and heavy precipitation events."]
[]
[null,null,"Coastal Flooding"]
[null,null,"High Risk","Medium Likelihood",null,null,null,null,null,null,null,null,null,null,null,null,null,"High Consequences"]
[null,null,null,"The data center is at risk for increased coastal flooding and impacts of sea level rise due to its coastal location. Sea level rise, in concert with storm surge events, may increase the intensity of flooding in the area of the data center, putting equipment at risk for damage. Hurricanes that have affected data center operations in recent history include Betsy in 1965, Camille in 1969, and Katrina in 2005. Between 1924-2009, sea levels have risen by 0.9 inches per decade, on average. Sea levels are projected to rise 2-4 inches by the 2020's, 6-10 inches by the 2050's, and 11-19 inches by the 2080's, greatly increasing the future risk of coastal flooding in this area.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Riverine flooding, increased intensity of storms, and sea level rise could result in flooding and corrosion of coastal infrastructure (due to contact with water, especially salt water). Flooding may also diminish the availability of resources or manufacturing capability, which could make it difficult for the data center to access certain supplies. Coastal flooding can also create broader impacts to coastal infrastructure upon which it relies, such as energy systems (though the data center has generators onsite), wastewater treatment, and stormwater management systems. Any significant disruptions to these systems would pose serious negative implications for the data center."]
[]
[]
[]
[null,"Summary"]
[null,null,"Supply Chain 1",null,null,{"$f":"IF(SupplyChain1=\"\",\"\",SupplyChain1)","v":""}]
[null,null,null,{"$f":"IF('Identify Supply Chains'!$E$22=\"\",\"No supply chain description\",'Identify Supply Chains'!$E$22)","v":"No supply chain description"}]
[]
[null,null,{"$f":"IF(SC1_T1=0,\"No threat listed\",SC1_T1)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$22=\"\",\"No threat description\",'Identify Threats'!$E$22)","v":"No threat description"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(C51:C124)","v":10}]
[null,null,{"$f":"IF(SC1_RL1=\"\",\"\",SC1_RL1&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC1_T1_L1=0,\"\",SC1_T1_L1)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC1_T1_C1=0,\"\",SC1_T1_C1)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$20=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$20)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$20=0,\"No consequence description\",'Identify Threat Consequence'!$G$20)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC1_T2=0,\"No threat listed\",SC1_T2)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$30=\"\",\"No threat description\",'Identify Threats'!$E$30)","v":"No threat description"}]
[null,null,{"$f":"IF(SC1_RL2=\"\",\"\",SC1_RL2&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC1_T2_L2=0,\"\",SC1_T2_L2)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC1_T2_C2=0,\"\",SC1_T2_C2)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$27=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$27)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$27=0,\"No consequence description\",'Identify Threat Consequence'!$G$27)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC1_T3=0,\"No threat listed\",SC1_T3)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$38=\"\",\"No threat description\",'Identify Threats'!$E$38)","v":"No threat description"}]
[null,null,{"$f":"IF(SC1_RL3=\"\",\"\",SC1_RL3&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC1_T3_L3=0,\"\",SC1_T3_L3)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC1_T3_C3=0,\"\",SC1_T3_C3)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$34=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$34)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$34=0,\"No consequence description\",'Identify Threat Consequence'!$G$34)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC1_T4=0,\"No threat listed\",SC1_T4)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$46=\"\",\"No threat description\",'Identify Threats'!$E$46)","v":"No threat description"}]
[null,null,{"$f":"IF(SC1_RL4=\"\",\"\",SC1_RL4&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC1_T4_L4=0,\"\",SC1_T4_L4)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC1_T4_C4=0,\"\",SC1_T4_C4)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$41=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$41)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$41=0,\"No consequence description\",'Identify Threat Consequence'!$G$41)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC1_T5=0,\"No threat listed\",SC1_T5)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$54=\"\",\"No threat description\",'Identify Threats'!$E$54)","v":"No threat description"}]
[null,null,{"$f":"IF(SC1_RL5=\"\",\"\",SC1_RL5&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC1_T5_L5=0,\"\",SC1_T5_L5)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC1_T5_C5=0,\"\",SC1_T5_C5)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$48=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$48)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$48=0,\"No consequence description\",'Identify Threat Consequence'!$G$48)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Supply Chain 2",null,null,{"$f":"IF(SupplyChain2=\"\",\"\",SupplyChain2)","v":""}]
[null,null,null,{"$f":"IF('Identify Supply Chains'!$E$31=\"\",\"No supply chain description\",'Identify Supply Chains'!$E$31)","v":"No supply chain description"}]
[]
[null,null,{"$f":"IF(SC2_T1=0,\"No threat listed\",SC2_T1)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$65=\"\",\"No threat description\",'Identify Threats'!$E$65)","v":"No threat description"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(C130:C203)","v":10}]
[null,null,{"$f":"IF(SC2_RL1=\"\",\"\",SC2_RL1&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC2_T1_L1=0,\"\",SC2_T1_L1)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC2_T1_C1=0,\"\",SC2_T1_C1)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$59=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$59)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$59=0,\"No consequence description\",'Identify Threat Consequence'!$G$59)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC2_T2=0,\"No threat listed\",SC2_T2)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$73=\"\",\"No threat description\",'Identify Threats'!$E$73)","v":"No threat description"}]
[null,null,{"$f":"IF(SC2_RL2=\"\",\"\",SC2_RL2&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC2_T2_L2=0,\"\",SC2_T2_L2)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC2_T2_C2=0,\"\",SC2_T2_C2)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$66=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$66)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$66=0,\"No consequence description\",'Identify Threat Consequence'!$G$66)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC2_T3=0,\"No threat listed\",SC2_T3)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$81=\"\",\"No threat description\",'Identify Threats'!$E$81)","v":"No threat description"}]
[null,null,{"$f":"IF(SC2_RL3=\"\",\"\",SC2_RL3&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC2_T3_L3=0,\"\",SC2_T3_L3)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC2_T3_C3=0,\"\",SC2_T3_C3)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$73=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$73)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$73=0,\"No consequence description\",'Identify Threat Consequence'!$G$73)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC2_T4=0,\"No threat listed\",SC2_T4)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$89=\"\",\"No threat description\",'Identify Threats'!$E$89)","v":"No threat description"}]
[null,null,{"$f":"IF(SC2_RL4=\"\",\"\",SC2_RL4&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC2_T4_L4=0,\"\",SC2_T4_L4)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC2_T4_C4=0,\"\",SC2_T4_C4)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$80=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$80)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$80=0,\"No consequence description\",'Identify Threat Consequence'!$G$80)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC2_T5=0,\"No threat listed\",SC2_T5)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$97=\"\", \"No threat description\",'Identify Threats'!$E$97)","v":"No threat description"}]
[null,null,{"$f":"IF(SC2_RL5=\"\",\"\",SC2_RL5&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC1_T5_L5=0,\"\",SC1_T5_L5)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC1_T5_C5=0,\"\",SC1_T5_C5)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$87=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$87)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$87=0,\"No consequence description\",'Identify Threat Consequence'!$G$87)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Supply Chain 3",null,null,{"$f":"IF(SupplyChain3=\"\",\"\",SupplyChain3)","v":""}]
[null,null,null,{"$f":"IF('Identify Supply Chains'!$E$40=\"\",\"No supply chain description\",'Identify Supply Chains'!$E$40)","v":"No supply chain description"}]
[]
[null,null,{"$f":"IF(SC3_T1=0,\"No threat listed\",SC3_T1)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$108=\"\",\"No threat description\", 'Identify Threats'!$E$108)","v":"No threat description"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(C209:C282)","v":10}]
[null,null,{"$f":"IF(SC3_RL1=\"\",\"\",SC3_RL1&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC3_T1_L1=0,\"\",SC3_T1_L1)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC3_T1_C1=0,\"\",SC3_T1_C1)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$98=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$98)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$98=0,\"No consequence description\",'Identify Threat Consequence'!$G$98)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC3_T2=0,\"No threat listed\",SC3_T2)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$116=\"\",\"No threat description\",'Identify Threats'!$E$116)","v":"No threat description"}]
[null,null,{"$f":"IF(SC3_RL2=\"\",\"\",SC3_RL2&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC3_T2_L2=0,\"\",SC3_T2_L2)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC3_T2_C2=0,\"\",SC3_T2_C2)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$105=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$105)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$105=0,\"No consequence description\",'Identify Threat Consequence'!$G$105)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC3_T3=0,\"No threat listed\",SC3_T3)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$124=\"\",\"No threat description\",'Identify Threats'!$E$124)","v":"No threat description"}]
[null,null,{"$f":"IF(SC3_RL3=\"\",\"\",SC3_RL3&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC3_T3_L3=0,\"\",SC3_T3_L3)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC3_T3_C3=0,\"\",SC3_T3_C3)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$112=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$112)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$112=0,\"No consequence description\",'Identify Threat Consequence'!$G$112)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC3_T4=0,\"No threat listed\",SC3_T4)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$132=\"\",\"No threat description\",'Identify Threats'!$E$132)","v":"No threat description"}]
[null,null,{"$f":"IF(SC3_RL4=\"\",\"\",SC3_RL4&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC3_T4_L4=0,\"\",SC3_T4_L4)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC3_T4_C4=0,\"\",SC3_T4_C4)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$119=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$119)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$119=0,\"No consequence description\",'Identify Threat Consequence'!$G$119)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC3_T5=0,\"No threat listed\",SC3_T5)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$140=\"\",\"No threat description\",'Identify Threats'!$E$140)","v":"No threat description"}]
[null,null,{"$f":"IF(SC3_RL5=\"\",\"\",SC3_RL5&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC3_T5_L5=0,\"\",SC3_T5_L5)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC3_T5_C5=0,\"\",SC3_T5_C5)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$126=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$126)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$126=0,\"No consequence description\",'Identify Threat Consequence'!$G$126)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Supply Chain 4",null,null,{"$f":"IF(SupplyChain4=\"\",\"\",SupplyChain4)","v":""}]
[null,null,null,{"$f":"IF('Identify Supply Chains'!$E$49=\"\",\"No supply chain description\",'Identify Supply Chains'!$E$49)","v":"No supply chain description"}]
[]
[null,null,{"$f":"IF(SC4_T1=0,\"No threat listed\",SC4_T1)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$151=\"\",\"No threat description\", 'Identify Threats'!$E$151)","v":"No threat description"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(C288:C361)","v":10}]
[null,null,{"$f":"IF(SC4_RL1=\"\",\"\",SC4_RL1&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC4_T1_L1=0,\"\",SC4_T1_L1)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC4_T1_C1=0,\"\",SC4_T1_C1)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$137=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$137)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$137=0,\"No consequence description\",'Identify Threat Consequence'!$G$137)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC4_T2=0,\"No threat listed\",SC4_T2)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$159=\"\",\"No threat description\",'Identify Threats'!$E$159)","v":"No threat description"}]
[null,null,{"$f":"IF(SC4_RL2=\"\",\"\",SC4_RL2&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC4_T2_L2=0,\"\",SC4_T2_L2)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC4_T2_C2=0,\"\",SC4_T2_C2)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$144=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$144)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$144=0,\"No consequence description\",'Identify Threat Consequence'!$G$144)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC4_T3=0,\"No threat listed\",SC4_T3)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$167=\"\",\"No threat description\",'Identify Threats'!$E$167)","v":"No threat description"}]
[null,null,{"$f":"IF(SC4_RL3=\"\",\"\",SC4_RL3&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC4_T3_L3=0,\"\",SC4_T3_L3)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC4_T3_C3=0,\"\",SC4_T3_C3)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$151=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$151)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$151=0,\"No consequence description\",'Identify Threat Consequence'!$G$151)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC4_T4=0,\"No threat listed\",SC4_T4)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$175=\"\",\"No threat description\",'Identify Threats'!$E$175)","v":"No threat description"}]
[null,null,{"$f":"IF(SC4_RL4=\"\",\"\",SC4_RL4&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC4_T4_L4=0,\"\",SC4_T4_L4)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC4_T4_C4=0,\"\",SC4_T4_C4)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$158=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$158)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$158=0,\"No consequence description\",'Identify Threat Consequence'!$G$158)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC4_T5=0,\"No threat listed\",SC4_T5)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$183=\"\",\"No threat description\",'Identify Threats'!$E$183)","v":"No threat description"}]
[null,null,{"$f":"IF(SC4_RL5=\"\",\"\",SC4_RL5&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC4_T5_L5=0,\"\",SC4_T5_L5)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC4_T5_C5=0,\"\",SC4_T5_C5)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$165=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$165)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$165=0,\"No consequence description\",'Identify Threat Consequence'!$G$165)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Supply Chain 5",null,null,{"$f":"IF(SupplyChain5=\"\",\"\",SupplyChain5)","v":""}]
[null,null,null,{"$f":"IF('Identify Supply Chains'!$E$58=\"\",\"No supply chain description\",'Identify Supply Chains'!$E$58)","v":"No supply chain description"}]
[]
[null,null,{"$f":"IF(SC5_T1=0,\"No threat listed\",SC5_T1)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$194=\"\",\"No threat description\", 'Identify Threats'!$E$194)","v":"No threat description"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(C367:C440)","v":10}]
[null,null,{"$f":"IF(SC5_RL1=\"\",\"\",SC5_RL1&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC5_T1_L1=0,\"\",SC5_T1_L1)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC5_T1_C1=0,\"\",SC5_T1_C1)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$176=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$176)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$176=0,\"No consequence description\",'Identify Threat Consequence'!$G$176)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC5_T2=0,\"No threat listed\",SC5_T2)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$202=\"\",\"No threat description\",'Identify Threats'!$E$202)","v":"No threat description"}]
[null,null,{"$f":"IF(SC5_RL2=\"\",\"\",SC5_RL2&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC5_T2_L2=0,\"\",SC5_T2_L2)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC5_T2_C2=0,\"\",SC5_T2_C2)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$183=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$183)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$183=0,\"No consequence description\",'Identify Threat Consequence'!$G$183)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC5_T3=0,\"No threat listed\",SC5_T3)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$210=\"\",\"No threat description\",'Identify Threats'!$E$210)","v":"No threat description"}]
[null,null,{"$f":"IF(SC5_RL3=\"\",\"\",SC5_RL3&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC5_T3_L3=0,\"\",SC5_T3_L3)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC5_T3_C3=0,\"\",SC5_T3_C3)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$190=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$190)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$190=0,\"No consequence description\",'Identify Threat Consequence'!$G$190)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC5_T4=0,\"No threat listed\",SC5_T4)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$218=\"\",\"No threat description\",'Identify Threats'!$E$218)","v":"No threat description"}]
[null,null,{"$f":"IF(SC5_RL4=\"\",\"\",SC5_RL4&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC5_T4_L4=0,\"\",SC5_T4_L4)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC5_T4_C4=0,\"\",SC5_T4_C4)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$197=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$197)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$197=0,\"No consequence description\",'Identify Threat Consequence'!$G$197)","v":"No consequence description"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(SC5_T5=0,\"No threat listed\",SC5_T5)","v":"No threat listed"},{"$f":"IF('Identify Threats'!$E$226=\"\",\"No threat description\",'Identify Threats'!$E$183)","v":"No threat description"}]
[null,null,{"$f":"IF(SC5_RL5=\"\",\"\",SC5_RL5&\" Risk\")","v":"No Entry Risk"}]
[]
[]
[]
[null,null,null,{"$f":"IF(SC5_T5_L5=0,\"\",SC5_T5_L5)&\" Likelihood\"","v":" Likelihood"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SC5_T5_C5=0,\"\",SC5_T5_C5)&\" Consequences\"","v":" Consequences"}]
[null,null,null,{"$f":"IF('Identify Threat Likelihood'!$G$204=\"\",\"No likelihood description\",'Identify Threat Likelihood'!$G$204)","v":"No likelihood description"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Identify Threat Consequence'!$G$204=0,\"No consequence description\",'Identify Threat Consequence'!$G$204)","v":"No consequence description"}]

{"sheet":"PR_Guidance","index":10,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Prioritize Climate Change Risks - Guidance"]

{"sheet":"Mitigate Risks","index":11,"n_rows":63,"n_cols":17,"rows_kept":63,"cut":false,"hidden":false,"merged":[[9,4,9,5],[9,6,9,7],[9,8,9,9],[8,4,8,5],[8,6,8,7],[8,8,8,9],[10,2,10,3],[11,2,11,3],[18,2,18,3],[16,8,16,9],[17,8,17,9],[9,2,9,3],[19,2,19,3],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[3,1,5,12],[20,2,20,3],[20,8,20,9],[18,8,18,9],[19,8,19,9],[18,6,18,7],[19,6,19,7],[10,8,10,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[18,4,18,5],[19,4,19,5],[10,6,10,7],[11,6,11,7],[12,6,12,7],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[8,2,8,3],[33,2,33,3],[34,2,34,3],[22,6,22,7],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[25,4,25,5],[26,4,26,5],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[29,6,29,7],[30,6,30,7],[31,6,31,7],[32,6,32,7],[33,6,33,7],[34,6,34,7],[33,4,33,5],[34,4,34,5],[20,6,20,7],[21,6,21,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[27,4,27,5],[28,4,28,5],[29,4,29,5],[30,4,30,5],[31,4,31,5],[32,4,32,5],[33,8,33,9],[34,8,34,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[31,8,31,9],[32,8,32,9],[27,8,27,9],[21,8,21,9],[22,8,22,9],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9]]}
[]
[null,"Identify Risk Mitigation Strategies and Points of Contact"]
[]
[null,"This page summarizes information entered in previous sections and provides space to briefly document strategies to address climate change risks and points of contact to implement those efforts (under the Plan, Owner, and Owner Contact Info. columns). You may print this page as well, using the \"Export to PDF\" button in the top right corner of the page."]
[]
[]
[]
[]
[null,"Supply Chain","Risk",null,"Likelihood",null,"Impact",null,"Risk Priority",null,"Risk Management Strategy","Owner","Owner Contact Info."]
[null,"Example: Data Centers","Coastal Flooding",null,"Medium",null,"High",null,"High",null,"Monitor magnitude of flooding year-to-year. Review building design to determine water levels it can withstand and identify contingency plan for events that surpass that threshold.","Jane Q, Real Estate Manager","Jane.Q@email.com"]
[null,{"$f":"IF(SupplyChain1=\"\",\"No entry\",SupplyChain1)","v":"No entry"},{"$f":"IF(SC1_T1=\"\",\"No entry\",SC1_T1)","v":"No entry"},null,{"$f":"IF(SC1_T1_L1=\"\",\"No entry\",SC1_T1_L1)","v":"No entry"},null,{"$f":"IF(SC1_T1_C1=\"\",\"No entry\",SC1_T1_C1)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E11,Lists!$G$2:$G$6,0),MATCH(G11,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"},null,null,null,null,null,null,null,{"$f":"COUNTA(K11:M15)","v":0}]
[null,{"$f":"IF(SupplyChain1=\"\",\"No entry\",SupplyChain1)","v":"No entry"},{"$f":"IF(SC1_T2=\"\",\"No entry\",SC1_T2)","v":"No entry"},null,{"$f":"IF(SC1_T2_L2=\"\",\"No entry\",SC1_T2_L2)","v":"No entry"},null,{"$f":"IF(SC1_T2_C2=\"\",\"No entry\",SC1_T2_C2)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E12,Lists!$G$2:$G$6,0),MATCH(G12,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain1=\"\",\"No entry\",SupplyChain1)","v":"No entry"},{"$f":"IF(SC1_T3=\"\",\"No entry\",SC1_T3)","v":"No entry"},null,{"$f":"IF(SC1_T3_L3=\"\",\"No entry\",SC1_T3_L3)","v":"No entry"},null,{"$f":"IF(SC1_T3_C3=\"\",\"No entry\",SC1_T3_C3)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E13,Lists!$G$2:$G$6,0),MATCH(G13,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain1=\"\",\"No entry\",SupplyChain1)","v":"No entry"},{"$f":"IF(SC1_T4=\"\",\"No entry\",SC1_T4)","v":"No entry"},null,{"$f":"IF(SC1_T4_L4=\"\",\"No entry\",SC1_T4_L4)","v":"No entry"},null,{"$f":"IF(SC1_T4_C4=\"\",\"No entry\",SC1_T4_C4)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E14,Lists!$G$2:$G$6,0),MATCH(G14,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain1=\"\",\"No entry\",SupplyChain1)","v":"No entry"},{"$f":"IF(SC1_T5=\"\",\"No entry\",SC1_T5)","v":"No entry"},null,{"$f":"IF(SC1_T5_L5=\"\",\"No entry\",SC1_T5_L5)","v":"No entry"},null,{"$f":"IF(SC1_T5_C5=\"\",\"No entry\",SC1_T5_C5)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E15,Lists!$G$2:$G$6,0),MATCH(G15,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain2=\"\",\"No entry\",SupplyChain2)","v":"No entry"},{"$f":"IF(SC2_T1=\"\",\"No entry\",SC2_T1)","v":"No entry"},null,{"$f":"IF(SC2_T1_L1=\"\",\"No entry\",SC2_T1_L1)","v":"No entry"},null,{"$f":"IF(SC2_T1_C1=\"\",\"No entry\",SC2_T1_C1)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E16,Lists!$G$2:$G$6,0),MATCH(G16,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"},null,null,null,null,null,null,null,{"$f":"COUNTA(K16:M20)","v":0}]
[null,{"$f":"IF(SupplyChain2=\"\",\"No entry\",SupplyChain2)","v":"No entry"},{"$f":"IF(SC2_T2=\"\",\"No entry\",SC2_T2)","v":"No entry"},null,{"$f":"IF(SC2_T2_L2=\"\",\"No entry\",SC2_T2_L2)","v":"No entry"},null,{"$f":"IF(SC2_T2_C2=\"\",\"No entry\",SC2_T2_C2)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E17,Lists!$G$2:$G$6,0),MATCH(G17,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain2=\"\",\"No entry\",SupplyChain2)","v":"No entry"},{"$f":"IF(SC2_T3=\"\",\"No entry\",SC2_T3)","v":"No entry"},null,{"$f":"IF(SC2_T3_L3=\"\",\"No entry\",SC2_T3_L3)","v":"No entry"},null,{"$f":"IF(SC2_T3_C3=\"\",\"No entry\",SC2_T3_C3)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E18,Lists!$G$2:$G$6,0),MATCH(G18,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain2=\"\",\"No entry\",SupplyChain2)","v":"No entry"},{"$f":"IF(SC2_T4=\"\",\"No entry\",SC2_T4)","v":"No entry"},null,{"$f":"IF(SC2_T4_L4=\"\",\"No entry\", SC2_T4_L4)","v":"No entry"},null,{"$f":"IF(SC2_T4_C4=\"\",\"No entry\", SC2_T4_C4)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E19,Lists!$G$2:$G$6,0),MATCH(G19,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain2=\"\",\"No entry\",SupplyChain2)","v":"No entry"},{"$f":"IF(SC2_T5=\"\",\"No entry\",SC2_T5)","v":"No entry"},null,{"$f":"IF(SC2_T5_L5=\"\",\"No entry\", SC2_T5_L5)","v":"No entry"},null,{"$f":"IF(SC2_T5_C5=\"\",\"No entry\", SC2_T5_C5)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E20,Lists!$G$2:$G$6,0),MATCH(G20,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain3=\"\",\"No entry\",SupplyChain3)","v":"No entry"},{"$f":"IF(SC3_T1=\"\",\"No entry\", SC3_T1)","v":"No entry"},null,{"$f":"IF(SC3_T1_L1=\"\",\"No entry\",SC3_T1_L1)","v":"No entry"},null,{"$f":"IF(SC3_T1_C1=\"\",\"No entry\",SC3_T1_C1)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E21,Lists!$G$2:$G$6,0),MATCH(G21,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"},null,null,null,null,null,null,null,{"$f":"COUNTA(K21:M25)","v":0}]
[null,{"$f":"IF(SupplyChain3=\"\",\"No entry\",SupplyChain3)","v":"No entry"},{"$f":"IF(SC3_T2=\"\",\"No entry\", SC3_T2)","v":"No entry"},null,{"$f":"IF(SC3_T2_L2=\"\",\"No entry\",SC3_T2_L2)","v":"No entry"},null,{"$f":"IF(SC3_T2_C2=\"\",\"No entry\",SC3_T2_C2)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E22,Lists!$G$2:$G$6,0),MATCH(G22,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain3=\"\",\"No entry\",SupplyChain3)","v":"No entry"},{"$f":"IF(SC3_T3=\"\",\"No entry\", SC3_T3)","v":"No entry"},null,{"$f":"IF(SC3_T3_L3=\"\",\"No entry\",SC3_T3_L3)","v":"No entry"},null,{"$f":"IF(SC3_T3_C3=\"\",\"No entry\",SC3_T3_C3)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E23,Lists!$G$2:$G$6,0),MATCH(G23,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain3=\"\",\"No entry\",SupplyChain3)","v":"No entry"},{"$f":"IF(SC3_T4=\"\",\"No entry\", SC3_T4)","v":"No entry"},null,{"$f":"IF(SC3_T4_L4=\"\",\"No entry\", SC3_T4_L4)","v":"No entry"},null,{"$f":"IF(SC3_T4_C4=\"\",\"No entry\", SC3_T4_C4)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E24,Lists!$G$2:$G$6,0),MATCH(G24,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain3=\"\",\"No entry\",SupplyChain3)","v":"No entry"},{"$f":"IF(SC3_T5=\"\",\"No entry\", SC3_T5)","v":"No entry"},null,{"$f":"IF(SC3_T5_L5=\"\",\"No entry\", SC3_T5_L5)","v":"No entry"},null,{"$f":"IF(SC3_T5_C5=\"\",\"No entry\", SC3_T5_C5)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E25,Lists!$G$2:$G$6,0),MATCH(G25,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain4=\"\",\"No entry\",SupplyChain4)","v":"No entry"},{"$f":"IF(SC4_T1=\"\",\"No entry\",SC4_T1)","v":"No entry"},null,{"$f":"IF(SC4_T1_L1=\"\",\"No entry\",SC4_T1_L1)","v":"No entry"},null,{"$f":"IF(SC4_T1_C1=\"\",\"No entry\",SC4_T1_C1)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E26,Lists!$G$2:$G$6,0),MATCH(G26,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"},null,null,null,null,null,null,null,{"$f":"COUNTA(K26:M30)","v":0}]
[null,{"$f":"IF(SupplyChain4=\"\",\"No entry\",SupplyChain4)","v":"No entry"},{"$f":"IF(SC4_T2=\"\",\"No entry\", SC4_T2)","v":"No entry"},null,{"$f":"IF(SC4_T2_L2=\"\",\"No entry\",SC4_T2_L2)","v":"No entry"},null,{"$f":"IF(SC4_T2_C2=\"\",\"No entry\",SC4_T2_C2)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E27,Lists!$G$2:$G$6,0),MATCH(G27,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain4=\"\",\"No entry\",SupplyChain4)","v":"No entry"},{"$f":"IF(SC4_T3=\"\",\"No entry\", SC4_T3)","v":"No entry"},null,{"$f":"IF(SC4_T3_L3=\"\",\"No entry\",SC4_T3_L3)","v":"No entry"},null,{"$f":"IF(SC4_T3_C3=\"\",\"No entry\",SC4_T3_C3)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E28,Lists!$G$2:$G$6,0),MATCH(G28,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain4=\"\",\"No entry\",SupplyChain4)","v":"No entry"},{"$f":"IF(SC4_T4=\"\",\"No entry\", SC4_T4)","v":"No entry"},null,{"$f":"IF(SC4_T4_L4=\"\",\"No entry\", SC4_T4_L4)","v":"No entry"},null,{"$f":"IF(SC4_T4_C4=\"\",\"No entry\", SC4_T4_C4)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E29,Lists!$G$2:$G$6,0),MATCH(G29,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain4=\"\",\"No entry\",SupplyChain4)","v":"No entry"},{"$f":"IF(SC4_T5=\"\",\"No entry\", SC4_T5)","v":"No entry"},null,{"$f":"IF(SC4_T5_L5=\"\",\"No entry\", SC4_T5_L5)","v":"No entry"},null,{"$f":"IF(SC4_T5_C5=\"\",\"No entry\", SC4_T5_C5)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E30,Lists!$G$2:$G$6,0),MATCH(G30,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain5=\"\",\"No entry\",SupplyChain5)","v":"No entry"},{"$f":"IF(SC5_T1=\"\",\"No entry\", SC5_T1)","v":"No entry"},null,{"$f":"IF(SC5_T1_L1=\"\",\"No entry\",SC5_T1_L1)","v":"No entry"},null,{"$f":"IF(SC5_T1_C1=\"\",\"No entry\",SC5_T1_C1)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E31,Lists!$G$2:$G$6,0),MATCH(G31,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"},null,null,null,null,null,null,null,{"$f":"COUNTA(K31:M35)","v":0}]
[null,{"$f":"IF(SupplyChain5=\"\",\"No entry\",SupplyChain5)","v":"No entry"},{"$f":"IF(SC5_T2=\"\",\"No entry\", SC5_T2)","v":"No entry"},null,{"$f":"IF(SC5_T2_L2=\"\",\"No entry\",SC5_T2_L2)","v":"No entry"},null,{"$f":"IF(SC5_T2_C2=\"\",\"No entry\",SC5_T2_C2)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E32,Lists!$G$2:$G$6,0),MATCH(G32,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain5=\"\",\"No entry\",SupplyChain5)","v":"No entry"},{"$f":"IF(SC5_T3=\"\",\"No entry\", SC5_T3)","v":"No entry"},null,{"$f":"IF(SC5_T3_L3=\"\",\"No entry\",SC5_T3_L3)","v":"No entry"},null,{"$f":"IF(SC5_T3_C3=\"\",\"No entry\",SC5_T3_C3)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E33,Lists!$G$2:$G$6,0),MATCH(G33,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain5=\"\",\"No entry\",SupplyChain5)","v":"No entry"},{"$f":"IF(SC5_T4=\"\",\"No entry\", SC5_T4)","v":"No entry"},null,{"$f":"IF(SC5_T4_L4=\"\",\"No entry\", SC5_T4_L4)","v":"No entry"},null,{"$f":"IF(SC5_T4_C4=\"\",\"No entry\", SC5_T4_C4)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E34,Lists!$G$2:$G$6,0),MATCH(G34,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[null,{"$f":"IF(SupplyChain5=\"\",\"No entry\",SupplyChain5)","v":"No entry"},{"$f":"IF(SC5_T5=\"\",\"No entry\", SC5_T5)","v":"No entry"},null,{"$f":"IF(SC5_T5_L5=\"\",\"No entry\", SC5_T5_L5)","v":"No entry"},null,{"$f":"IF(SC5_T5_C5=\"\",\"No entry\", SC5_T5_C5)","v":"No entry"},null,{"$f":"IFERROR(INDEX(RiskMatrix,MATCH(E35,Lists!$G$2:$G$6,0),MATCH(G35,Lists!$H$7:$L$7,0)),\"More information needed\")","v":"More information needed"}]
[]
[]
[]
[]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]
[null,null,"No entry","No entry"]

{"sheet":"MR_Guidance","index":12,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,1,9,8],[10,1,10,6],[11,1,11,6],[5,1,5,7],[6,1,6,6],[7,1,7,6],[8,1,8,9]]}
[]
[null,"Assess Magnitude of Consequences of Threats - Guidance"]
[]
[]
[null,"Table of Contents"]
[null,"What Can Be Done to Reduce the Consequences of Climate Change"]
[null,"Identify Who Is Accountable for the Supply Chain"]
[null,"Develop Climate Change Risk Management Strategies"]
[null,"Evaluate the Risk Management Strategies to Select which Strategies to Implement"]
[null,"Monitor and Modify: How Effective Are the Risk Management Strategies?"]
[null,"Track the Impact of Weather Events over Time"]
[null,"Revisit and Update the Assessment and Plan"]

{"sheet":"Lists","index":13,"n_rows":68,"n_cols":23,"rows_kept":68,"cut":false,"hidden":true,"merged":[[1,16,1,18],[1,5,5,5]]}
[null,null,null,null,null,null,null,"Risk Matrix",null,null,null,null,"Risk","Risk Number"]
[null,null,"Magnitude of Impact","Likelihood of Consequence",null,"Likelihood","Very High","Medium","Medium","High","Extreme","Extreme","Low",1,null,null,"Risk Count"]
[null,null,"Catastrophic","Very High",5,null,"High","Low","Medium","High","High","Extreme","Medium",2,null,"Supply Chains","Extreme","High","Medium","Low","Risk Total","Rank"]
[null,null,"Major","High",4,null,"Moderate","Low","Medium","Medium","High","High","High",3,null,null,10,7,4,1]
[null,null,"Moderate","Moderate",3,null,"Low","Low","Low","Medium","Medium","Medium","Extreme",4,{"$f":"IF(U5=\"\",\"\",V5)","v":1},{"$f":"IF(SupplyChain1=\"\",\"\",SupplyChain1)","v":""},{"$f":"COUNTIFS($C$12:$C$36,$P5,$M$12:$M$36,Q$3)","v":0},0,0,0,{"$f":"SUMPRODUCT($Q$4:$T$4,$Q5:$T5)","v":0},{"$f":"IFERROR(RANK($U5,$U$5:$U$9),\"\")","v":1},{"$f":"IF(COUNTIF($V$5:$V$9,V5)>1,IF(Q5>VLOOKUP(V5,$O6:$T$9,3,FALSE),V5,V5+1),V5)","v":2}]
[null,null,"Minor","Low",2,null,"Very Low","Low","Low","Low","Low","Medium","No Entry",0,{"$f":"IF(U6=\"\",\"\",V6)","v":1},{"$f":"IF(SupplyChain2=\"\",\"\",SupplyChain2)","v":""},0,0,0,0,{"$f":"SUMPRODUCT($Q$4:$T$4,$Q6:$T6)","v":0},{"$f":"IFERROR(RANK($U6,$U$5:$U$9),\"\")","v":1},{"$f":"IF(COUNTIF($V$5:$V$9,V6)>1,IF(Q6>VLOOKUP(V6,$O7:$T$9,3,FALSE),V6,V6+1),V6)","v":2}]
[null,null,"Insignificant","Very Low",1,null,null,"Insignificant","Minor","Moderate","Major","Catastrophic",null,null,{"$f":"IF(U7=\"\",\"\",V7)","v":1},{"$f":"IF(SupplyChain3=\"\",\"\",SupplyChain3)","v":""},0,0,0,0,0,{"$f":"IFERROR(RANK($U7,$U$5:$U$9),\"\")","v":1},{"$f":"IF(COUNTIF($V$5:$V$9,V7)>1,IF(Q7>VLOOKUP(V7,$O8:$T$9,3,FALSE),V7,V7+1),V7)","v":2}]
[null,null,null,null,null,null,null,"Magnitude of Impact",null,null,null,null,null,null,{"$f":"IF(U8=\"\",\"\",V8)","v":1},{"$f":"IF(SupplyChain4=\"\",\"\",SupplyChain4)","v":""},0,0,0,0,0,{"$f":"IFERROR(RANK($U8,$U$5:$U$9),\"\")","v":1},{"$f":"IF(COUNTIF($V$5:$V$9,V8)>1,IF(Q8>VLOOKUP(V8,$O9:$T$9,3,FALSE),V8,V8+1),V8)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U9=\"\",\"\",V9)","v":1},{"$f":"IF(SupplyChain5=\"\",\"\",SupplyChain5)","v":""},0,0,0,0,0,{"$f":"IFERROR(RANK($U9,$U$5:$U$9),\"\")","v":1},{"$f":"IF(COUNTIF($V$5:$V$9,V9)>1,IF(Q9>VLOOKUP(V9,$O$9:$S9,3,FALSE),V9,V9+1),V9)","v":2}]
[null,null,null,null,null,null,"x-axis","y-axis"]
["Risk #","SC #","Supply Chain","Threat","Likelihood","Impact","Impact Number","Likelihood Number","X Adjustment","Y Adjustment","Adjusted x-axis","Adjusted y-axis","Risk Level","Risk Number","Graph Coordinates","Count","Count Order","Combination","Symbol"]
[1,1,{"$f":"IF($D12=\"\",\"\",IF(SupplyChain1=0,\"\",SupplyChain1))","v":""},{"$f":"IF(SC1_T1=0,\"\",SC1_T1)","v":""},{"$f":"IF(SC1_T1_L1=0,\"\",SC1_T1_L1)","v":""},{"$f":"IF(SC1_T1_C1=0,\"\",SC1_T1_C1)","v":""},{"$f":"IFERROR(VLOOKUP($F12,$C$3:$E$7,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($E12,$D$3:$E$7,2,FALSE),0)","v":0},{"$f":"LEFT(INDEX(PlottingGuide,$P12,$Q12),1)/6","v":0.33333333333333331},{"$f":"RIGHT(INDEX(PlottingGuide,$P12,$Q12),1)/6","v":0.66666666666666663},{"$f":"IFERROR(G12+I12,\"\")","v":0.33333333333333331},{"$f":"IFERROR(H12+J12,\"\")","v":0.66666666666666663},{"$f":"IFERROR(INDEX(RiskMatrix,MATCH($E12,$G$2:$G$6,0),MATCH($F12,$H$7:$L$7,0)),\"No Entry\")","v":"No Entry"},{"$f":"VLOOKUP(M12,$M$2:$N$6,2,FALSE)","v":0},{"$f":"\"(\"&K12&\",\"&L12&\")\"","v":"(0.333333333333333,0.666666666666667)"},{"$f":"COUNTIF($R$12:$R$36,$R12)","v":25},{"$f":"COUNTIF($R$12:$R12,$R12)","v":1},{"$f":"E12 & F12","v":""},"¢",null,null,null,{"$f":"IF(SupplyChain1=\"\",\"\",SupplyChain1)","v":""}]
[{"$f":"A12+1","v":2},1,{"$f":"IF($D13=\"\",\"\",IF(SupplyChain1=0,\"\",SupplyChain1))","v":""},{"$f":"IF(SC1_T2=0,\"\",SC1_T2)","v":""},{"$f":"IF(SC1_T2_L2=0,\"\",SC1_T2_L2)","v":""},{"$f":"IF(SC1_T2_C2=0,\"\",SC1_T2_C2)","v":""},{"$f":"IFERROR(VLOOKUP($F13,$C$3:$E$7,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP($E13,$D$3:$E$7,2,FALSE),0)","v":0},0.5,0.66666666666666663,0.5,0.66666666666666663,"No Entry",{"$f":"VLOOKUP(M13,$M$2:$N$6,2,FALSE)","v":0},{"$f":"\"(\"&K13&\",\"&L13&\")\"","v":"(0.5,0.666666666666667)"},25,{"$f":"COUNTIF($R$12:$R13,$R13)","v":2},"","Å",null,null,null,{"$f":"IF(SupplyChain2=\"\",\"\",SupplyChain2)","v":""}]
[{"$f":"A13+1","v":3},1,{"$f":"IF($D14=\"\",\"\",IF(SupplyChain1=0,\"\",SupplyChain1))","v":""},{"$f":"IF(SC1_T3=0,\"\",SC1_T3)","v":""},{"$f":"IF(SC1_T3_L3=0,\"\",SC1_T3_L3)","v":""},{"$f":"IF(SC1_T3_C3=0,\"\",SC1_T3_C3)","v":""},0,0,0.66666666666666663,0.66666666666666663,0.66666666666666663,0.66666666666666663,"No Entry",0,"(0.666666666666667,0.666666666666667)",25,{"$f":"COUNTIF($R$12:$R14,$R14)","v":3},"","æ",null,null,null,{"$f":"IF(SupplyChain3=\"\",\"\",SupplyChain3)","v":""}]
[4,1,{"$f":"IF($D15=\"\",\"\",IF(SupplyChain1=0,\"\",SupplyChain1))","v":""},{"$f":"IF(SC1_T4=0,\"\",SC1_T4)","v":""},{"$f":"IF(SC1_T4_L4=0,\"\",SC1_T4_L4)","v":""},{"$f":"IF(SC1_T4_C4=0,\"\",SC1_T4_C4)","v":""},0,0,0.33333333333333331,0.5,0.33333333333333331,0.5,"No Entry",0,"(0.333333333333333,0.5)",25,{"$f":"COUNTIF($R$12:$R15,$R15)","v":4},"","®",null,null,null,{"$f":"IF(SupplyChain4=\"\",\"\",SupplyChain4)","v":""}]
[5,1,{"$f":"IF($D16=\"\",\"\",IF(SupplyChain1=0,\"\",SupplyChain1))","v":""},{"$f":"IF(SC1_T5=0,\"\",SC1_T5)","v":""},{"$f":"IF(SC1_T5_L5=0,\"\",SC1_T5_L5)","v":""},{"$f":"IF(SC1_T5_C5=0,\"\",SC1_T5_C5)","v":""},0,0,0.5,0.5,0.5,0.5,"No Entry",0,"(0.5,0.5)",25,{"$f":"COUNTIF($R$12:$R16,$R16)","v":5},"","Ú",null,null,null,{"$f":"IF(SupplyChain5=\"\",\"\",SupplyChain5)","v":""}]
[6,2,{"$f":"IF($D17=\"\",\"\",IF(SupplyChain2=0,\"\",SupplyChain2))","v":""},{"$f":"IF(SC2_T1=0,\"\",SC2_T1)","v":""},{"$f":"IF(SC2_T1_L1=0,\"\",SC2_T1_L1)","v":""},{"$f":"IF(SC2_T1_C1=0,\"\",SC2_T1_C1)","v":""},0,0,0.66666666666666663,0.5,0.66666666666666663,0.5,"No Entry",0,"(0.666666666666667,0.5)",25,{"$f":"COUNTIF($R$12:$R17,$R17)","v":6},"","¢"]
[7,2,{"$f":"IF($D18=\"\",\"\",IF(SupplyChain2=0,\"\",SupplyChain2))","v":""},{"$f":"IF(SC2_T2=0,\"\",SC2_T2)","v":""},{"$f":"IF(SC2_T2_L2=0,\"\",SC2_T2_L2)","v":""},{"$f":"IF(SC2_T2_C2=0,\"\",SC2_T2_C2)","v":""},0,0,0.33333333333333331,0.33333333333333331,0.33333333333333331,0.33333333333333331,"No Entry",0,"(0.333333333333333,0.333333333333333)",25,{"$f":"COUNTIF($R$12:$R18,$R18)","v":7},"","Å"]
[8,2,{"$f":"IF($D19=\"\",\"\",IF(SupplyChain2=0,\"\",SupplyChain2))","v":""},{"$f":"IF(SC2_T3=0,\"\",SC2_T3)","v":""},{"$f":"IF(SC2_T3_L3=0,\"\",SC2_T3_L3)","v":""},{"$f":"IF(SC2_T3_C3=0,\"\",SC2_T3_C3)","v":""},0,0,0.5,0.33333333333333331,0.5,0.33333333333333331,"No Entry",0,"(0.5,0.333333333333333)",25,{"$f":"COUNTIF($R$12:$R19,$R19)","v":8},"","æ"]
[9,2,{"$f":"IF($D20=\"\",\"\",IF(SupplyChain2=0,\"\",SupplyChain2))","v":""},{"$f":"IF(SC2_T4=0,\"\",SC2_T4)","v":""},{"$f":"IF(SC2_T4_L4=0,\"\",SC2_T4_L4)","v":""},{"$f":"IF(SC2_T4_C4=0,\"\",SC2_T4_C4)","v":""},0,0,0.66666666666666663,0.33333333333333331,0.66666666666666663,0.33333333333333331,"No Entry",0,"(0.666666666666667,0.333333333333333)",25,{"$f":"COUNTIF($R$12:$R20,$R20)","v":9},"","®"]
[10,2,{"$f":"IF($D21=\"\",\"\",IF(SupplyChain2=0,\"\",SupplyChain2))","v":""},{"$f":"IF(SC2_T5=0,\"\",SC2_T5)","v":""},{"$f":"IF(SC2_T5_L5=0,\"\",SC2_T5_L5)","v":""},{"$f":"IF(SC2_T5_C5=0,\"\",SC2_T5_C5)","v":""},0,0,0.83333333333333337,0.66666666666666663,0.83333333333333337,0.66666666666666663,"No Entry",0,"(0.833333333333333,0.666666666666667)",25,{"$f":"COUNTIF($R$12:$R21,$R21)","v":10},"","Ú"]
[11,3,{"$f":"IF($D22=\"\",\"\",IF(SupplyChain3=0,\"\",SupplyChain3))","v":""},{"$f":"IF(SC3_T1=0,\"\",SC3_T1)","v":""},{"$f":"IF(SC3_T1_L1=0,\"\",SC3_T1_L1)","v":""},{"$f":"IF(SC3_T1_C1=0,\"\",SC3_T1_C1)","v":""},0,0,0.16666666666666666,0.66666666666666663,0.16666666666666666,0.66666666666666663,"No Entry",0,"(0.166666666666667,0.666666666666667)",25,{"$f":"COUNTIF($R$12:$R22,$R22)","v":11},"","¢"]
[12,3,{"$f":"IF($D23=\"\",\"\",IF(SupplyChain3=0,\"\",SupplyChain3))","v":""},{"$f":"IF(SC3_T2=0,\"\",SC3_T2)","v":""},{"$f":"IF(SC3_T2_L2=0,\"\",SC3_T2_L2)","v":""},{"$f":"IF(SC3_T2_C2=0,\"\",SC3_T2_C2)","v":""},0,0,0.16666666666666666,0.33333333333333331,0.16666666666666666,0.33333333333333331,"No Entry",0,"(0.166666666666667,0.333333333333333)",25,{"$f":"COUNTIF($R$12:$R23,$R23)","v":12},"","Å"]
[13,3,{"$f":"IF($D24=\"\",\"\",IF(SupplyChain3=0,\"\",SupplyChain3))","v":""},{"$f":"IF(SC3_T3=0,\"\",SC3_T3)","v":""},{"$f":"IF(SC3_T3_L3=0,\"\",SC3_T3_L3)","v":""},{"$f":"IF(SC3_T3_C3=0,\"\",SC3_T3_C3)","v":""},0,0,0.83333333333333337,0.33333333333333331,0.83333333333333337,0.33333333333333331,"No Entry",0,"(0.833333333333333,0.333333333333333)",25,{"$f":"COUNTIF($R$12:$R24,$R24)","v":13},"","æ"]
[14,3,{"$f":"IF($D25=\"\",\"\",IF(SupplyChain3=0,\"\",SupplyChain3))","v":""},{"$f":"IF(SC3_T4=0,\"\",SC3_T4)","v":""},{"$f":"IF(SC3_T4_L4=0,\"\",SC3_T4_L4)","v":""},{"$f":"IF(SC3_T4_C4=0,\"\",SC3_T4_C4)","v":""},0,0,0.83333333333333337,0.5,0.83333333333333337,0.5,"No Entry",0,"(0.833333333333333,0.5)",25,{"$f":"COUNTIF($R$12:$R25,$R25)","v":14},"","®"]
[15,3,{"$f":"IF($D26=\"\",\"\",IF(SupplyChain3=0,\"\",SupplyChain3))","v":""},{"$f":"IF(SC3_T5=0,\"\",SC3_T5)","v":""},{"$f":"IF(SC3_T5_L5=0,\"\",SC3_T5_L5)","v":""},{"$f":"IF(SC3_T5_C5=0,\"\",SC3_T5_C5)","v":""},0,0,0.16666666666666666,0.5,0.16666666666666666,0.5,"No Entry",0,"(0.166666666666667,0.5)",25,{"$f":"COUNTIF($R$12:$R26,$R26)","v":15},"","Ú"]
[16,4,{"$f":"IF($D27=\"\",\"\",IF(SupplyChain4=0,\"\",SupplyChain4))","v":""},{"$f":"IF(SC4_T1=0,\"\",SC4_T1)","v":""},{"$f":"IF(SC4_T1_L1=0,\"\",SC4_T1_L1)","v":""},{"$f":"IF(SC4_T1_C1=0,\"\",SC4_T1_C1)","v":""},0,0,0.33333333333333331,0.16666666666666666,0.33333333333333331,0.16666666666666666,"No Entry",0,"(0.333333333333333,0.166666666666667)",25,{"$f":"COUNTIF($R$12:$R27,$R27)","v":16},"","¢"]
[17,4,{"$f":"IF($D28=\"\",\"\",IF(SupplyChain4=0,\"\",SupplyChain4))","v":""},{"$f":"IF(SC4_T2=0,\"\",SC4_T2)","v":""},{"$f":"IF(SC4_T2_L2=0,\"\",SC4_T2_L2)","v":""},{"$f":"IF(SC4_T2_C2=0,\"\",SC4_T2_C2)","v":""},0,0,0.66666666666666663,0.16666666666666666,0.66666666666666663,0.16666666666666666,"No Entry",0,"(0.666666666666667,0.166666666666667)",25,{"$f":"COUNTIF($R$12:$R28,$R28)","v":17},"","Å"]
[18,4,{"$f":"IF($D29=\"\",\"\",IF(SupplyChain4=0,\"\",SupplyChain4))","v":""},{"$f":"IF(SC4_T3=0,\"\",SC4_T3)","v":""},{"$f":"IF(SC4_T3_L3=0,\"\",SC4_T3_L3)","v":""},{"$f":"IF(SC4_T3_C3=0,\"\",SC4_T3_C3)","v":""},0,0,0.33333333333333331,0.83333333333333337,0.33333333333333331,0.83333333333333337,"No Entry",0,"(0.333333333333333,0.833333333333333)",25,{"$f":"COUNTIF($R$12:$R29,$R29)","v":18},"","æ"]
[19,4,{"$f":"IF($D30=\"\",\"\",IF(SupplyChain4=0,\"\",SupplyChain4))","v":""},{"$f":"IF(SC4_T4=0,\"\",SC4_T4)","v":""},{"$f":"IF(SC4_T4_L4=0,\"\",SC4_T4_L4)","v":""},{"$f":"IF(SC4_T4_C4=0,\"\",SC4_T4_C4)","v":""},0,0,0.5,0.83333333333333337,0.5,0.83333333333333337,"No Entry",0,"(0.5,0.833333333333333)",25,{"$f":"COUNTIF($R$12:$R30,$R30)","v":19},"","®"]
[20,4,{"$f":"IF($D31=\"\",\"\",IF(SupplyChain4=0,\"\",SupplyChain4))","v":""},{"$f":"IF(SC4_T5=0,\"\",SC4_T5)","v":""},{"$f":"IF(SC4_T5_L5=0,\"\",SC4_T5_L5)","v":""},{"$f":"IF(SC4_T5_C5=0,\"\",SC4_T5_C5)","v":""},0,0,0.66666666666666663,0.83333333333333337,0.66666666666666663,0.83333333333333337,"No Entry",0,"(0.666666666666667,0.833333333333333)",25,{"$f":"COUNTIF($R$12:$R31,$R31)","v":20},"","Ú"]
[21,5,{"$f":"IF($D32=\"\",\"\",IF(SupplyChain5=0,\"\",SupplyChain5))","v":""},{"$f":"IF(SC5_T1=0,\"\",SC5_T1)","v":""},{"$f":"IF(SC5_T1_L1=0,\"\",SC5_T1_L1)","v":""},{"$f":"IF(SC5_T1_C1=0,\"\",SC5_T1_C1)","v":""},0,0,0.5,0.16666666666666666,0.5,0.16666666666666666,"No Entry",0,"(0.5,0.166666666666667)",25,{"$f":"COUNTIF($R$12:$R32,$R32)","v":21},"","¢"]
[22,5,{"$f":"IF($D33=\"\",\"\",IF(SupplyChain5=0,\"\",SupplyChain5))","v":""},{"$f":"IF(SC5_T2=0,\"\",SC5_T2)","v":""},{"$f":"IF(SC5_T2_L2=0,\"\",SC5_T2_L2)","v":""},{"$f":"IF(SC5_T2_C2=0,\"\",SC5_T2_C2)","v":""},0,0,0.16666666666666666,0.83333333333333337,0.16666666666666666,0.83333333333333337,"No Entry",0,"(0.166666666666667,0.833333333333333)",25,{"$f":"COUNTIF($R$12:$R33,$R33)","v":22},"","Å"]
[23,5,{"$f":"IF($D34=\"\",\"\",IF(SupplyChain5=0,\"\",SupplyChain5))","v":""},{"$f":"IF(SC5_T3=0,\"\",SC5_T3)","v":""},{"$f":"IF(SC5_T3_L3=0,\"\",SC5_T3_L3)","v":""},{"$f":"IF(SC5_T3_C3=0,\"\",SC5_T3_C3)","v":""},0,0,0.83333333333333337,0.83333333333333337,0.83333333333333337,0.83333333333333337,"No Entry",0,"(0.833333333333333,0.833333333333333)",25,{"$f":"COUNTIF($R$12:$R34,$R34)","v":23},"","æ"]
[24,5,{"$f":"IF($D35=\"\",\"\",IF(SupplyChain5=0,\"\",SupplyChain5))","v":""},{"$f":"IF(SC5_T4=0,\"\",SC5_T4)","v":""},{"$f":"IF(SC5_T4_L4=0,\"\",SC5_T4_L4)","v":""},{"$f":"IF(SC5_T4_C4=0,\"\",SC5_T4_C4)","v":""},0,0,0.16666666666666666,0.16666666666666666,0.16666666666666666,0.16666666666666666,"No Entry",0,"(0.166666666666667,0.166666666666667)",25,{"$f":"COUNTIF($R$12:$R35,$R35)","v":24},"","®"]
[25,5,{"$f":"IF($D36=\"\",\"\",IF(SupplyChain5=0,\"\",SupplyChain5))","v":""},{"$f":"IF(SC5_T5=0,\"\",SC5_T5)","v":""},{"$f":"IF(SC5_T5_L5=0,\"\",SC5_T5_L5)","v":""},{"$f":"IF(SC5_T5_C5=0,\"\",SC5_T5_C5)","v":""},0,0,0.83333333333333337,0.16666666666666666,0.83333333333333337,0.16666666666666666,"No Entry",0,"(0.833333333333333,0.166666666666667)",25,{"$f":"COUNTIF($R$12:$R36,$R36)","v":25},"","Ú"]
[]
[null,null,"Priority Threats - for macro use only"]
[null,null,"Threat","Supply Chain","Rating","Symbol","Supply Chain"]
[null,{"$f":"B39+1","v":1},null,null,null,"¢",1,{"$f":"IFERROR(LOOKUP(E40,$N$2:$N$6,$M$2:$M$6),\"No Entry\")","v":"No Entry"}]
[null,2,null,null,null,"Å",1,"No Entry"]
[null,3,null,null,null,"æ",1,"No Entry"]
[null,4,null,null,null,"®",1,"No Entry"]
[null,5,null,null,null,"Ú",1,"No Entry"]
[null,6,null,null,null,"¢",2,"No Entry"]
[null,7,null,null,null,"Å",2,"No Entry"]
[null,8,null,null,null,"æ",2,"No Entry"]
[null,9,null,null,null,"®",2,"No Entry"]
[null,10,null,null,null,"Ú",2,"No Entry"]
[null,11,null,null,null,"¢",3,"No Entry"]
[null,12,null,null,null,"Å",3,"No Entry"]
[null,13,null,null,null,"æ",3,"No Entry"]
[null,14,null,null,null,"®",3,"No Entry"]
[null,15,null,null,null,"Ú",3,"No Entry"]
[null,16,null,null,null,"¢",4,"No Entry"]
[null,17,null,null,null,"Å",4,"No Entry"]
[null,18,null,null,null,"æ",4,"No Entry"]
[null,19,null,null,null,"®",4,"No Entry"]
[null,20,null,null,null,"Ú",4,"No Entry"]
[null,21,null,null,null,"¢",5,"No Entry"]
[null,22,null,null,null,"Å",5,"No Entry"]
[null,23,null,null,null,"æ",5,"No Entry"]
[null,24,null,null,null,"®",5,"No Entry"]
[null,25,null,null,null,"Ú",5,"No Entry"]
[]
[]
[null,null,"Priority Supply Chain Pull"]
[null,null,"Ranking","Supply Chain"]

{"sheet":"Plot","index":14,"n_rows":66,"n_cols":48,"rows_kept":66,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[1,null,1,2,3,4,5,2,null,1,2,3,4,5,3,null,1,2,3,4,5,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[null,5,null,null,null,null,null,null,5,null,null,null,null,null,null,5,null,null,null,null,null,null,1,"3,3"]
[null,4,null,null,null,null,null,null,4,null,null,null,null,null,null,4,null,null,null,null,null,null,2,"2,3","4,3"]
[null,3,null,null,null,null,null,null,3,null,null,null,null,null,null,3,null,null,null,null,null,null,3,"2,3","3,3","4,3"]
[null,2,null,null,null,null,null,null,2,null,null,null,null,null,null,2,null,null,null,null,null,null,4,"2,4","2,2","4,2","4,4"]
[null,1,null,null,null,null,null,null,1,null,null,null,null,null,null,1,null,null,null,null,null,null,5,"2,4","2,2","4,2","4,4","3,3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"2,2","3,2","4,2","2,4","3,4","4,4"]
[4,null,1,2,3,4,5,5,null,1,2,3,4,5,6,null,1,2,3,4,5,null,7,"2,2","3,2","4,2","2,4","3,4","4,4","3,3"]
[null,5,null,null,null,null,null,null,5,null,null,null,null,null,null,5,null,null,null,null,null,null,8,"2,4","3,4","4,4","2,3","4,3","2,2","3,2","4,2"]
[null,4,null,null,null,null,null,null,4,null,null,null,null,null,null,4,null,null,null,null,null,null,9,"2,4","3,4","4,4","2,3","3,3","4,3","2,2","3,2","4,2"]
[null,3,null,null,null,null,null,null,3,null,null,null,null,null,null,3,null,null,null,null,null,null,10,"2,4","3,4","4,4","2,3","3,3","4,3","2,2","3,2","4,2","5,4"]
[null,2,null,null,null,null,null,null,2,null,null,null,null,null,null,2,null,null,null,null,null,null,11,"2,4","3,4","4,4","2,3","3,3","4,3","2,2","3,2","4,2","5,4","1,4"]
[null,1,null,null,null,null,null,null,1,null,null,null,null,null,null,1,null,null,null,null,null,null,12,"2,4","3,4","4,4","2,3","3,3","4,3","2,2","3,2","4,2","5,4","1,4","1,2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"2,4","3,4","4,4","2,3","3,3","4,3","2,2","3,2","4,2","5,4","1,4","1,2","5,2"]
[7,null,1,2,3,4,5,8,null,1,2,3,4,5,9,null,1,2,3,4,5,null,14,"2,4","3,4","4,4","2,3","3,3","4,3","2,2","3,2","4,2","5,4","1,4","1,2","5,2","5,3"]
[null,5,null,null,null,null,null,null,5,null,null,null,null,null,null,5,null,null,null,null,null,null,15,"2,4","3,4","4,4","2,3","3,3","4,3","2,2","3,2","4,2","5,4","1,4","1,2","5,2","5,3","1,3"]
[null,4,null,null,null,null,null,null,4,null,null,null,null,null,null,4,null,null,null,null,null,null,16,"2,4","3,4","4,4","2,3","3,3","4,3","2,2","3,2","4,2","5,4","1,4","1,2","5,2","5,3","1,3","3,5"]
[null,3,null,null,null,null,null,null,3,null,null,null,null,null,null,3,null,null,null,null,null,null,17,"2,4","3,4","4,4","2,3","3,3","4,3","2,2","3,2","4,2","5,4","1,4","1,2","5,2","5,3","1,3","3,5","3,1"]
[null,2,null,null,null,null,null,null,2,null,null,null,null,null,null,2,null,null,null,null,null,null,18,"2,4","3,4","4,4","2,3","3,3","4,3","2,2","3,2","4,2","5,4","1,4","1,2","5,2","5,3","1,3","3,5","2,1","4,1"]
[null,1,null,null,null,null,null,null,1,null,null,null,null,null,null,1,null,null,null,null,null,null,19,"2,4","3,4","4,4","2,3","3,3","4,3","2,2","3,2","4,2","5,4","1,4","1,2","5,2","5,3","1,3","2,1","4,1","2,5","4,5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"2,4","3,4","4,4","2,3","3,3","4,3","2,2","3,2","4,2","5,4","1,4","1,2","5,2","5,3","1,3","2,1","4,1","2,5","3,5","4,5"]
[10,null,1,2,3,4,5,11,null,1,2,3,4,5,12,null,1,2,3,4,5,null,21,"2,4","3,4","4,4","2,3","3,3","4,3","2,2","3,2","4,2","5,4","1,4","1,2","5,2","5,3","1,3","2,1","4,1","2,5","3,5","4,5","3,1"]
[null,5,null,null,null,null,null,null,5,null,null,null,null,null,null,5,null,null,null,null,null,null,22,"2,4","3,4","4,4","2,3","3,3","4,3","2,2","3,2","4,2","5,4","1,4","1,2","5,2","5,3","1,3","2,1","4,1","2,5","3,5","4,5","3,1","1,5"]
[null,4,null,null,null,null,null,null,4,null,null,null,null,null,null,4,null,null,null,null,null,null,23,"2,4","3,4","4,4","2,3","3,3","4,3","2,2","3,2","4,2","5,4","1,4","1,2","5,2","5,3","1,3","2,1","4,1","2,5","3,5","4,5","3,1","1,5","5,5"]
[null,3,null,null,null,null,null,null,3,null,null,null,null,null,null,3,null,null,null,null,null,null,24,"2,4","3,4","4,4","2,3","3,3","4,3","2,2","3,2","4,2","5,4","1,4","1,2","5,2","5,3","1,3","2,1","4,1","2,5","3,5","4,5","3,1","1,5","5,5","1,1"]
[null,2,null,null,null,null,null,null,2,null,null,null,null,null,null,2,null,null,null,null,null,null,25,"2,4","3,4","4,4","2,3","3,3","4,3","2,2","3,2","4,2","5,4","1,4","1,2","5,2","5,3","1,3","2,1","4,1","2,5","3,5","4,5","3,1","1,5","5,5","1,1","5,1"]
[null,1,null,null,null,null,null,null,1,null,null,null,null,null,null,1]
[]
[13,null,1,2,3,4,5,14,null,1,2,3,4,5,15,null,1,2,3,4,5]
[null,5,null,null,null,null,null,null,5,null,null,null,null,null,null,5]
[null,4,null,null,null,null,null,null,4,null,null,null,null,null,null,4]
[null,3,null,null,null,null,null,null,3,null,null,null,null,null,null,3]
[null,2,null,null,null,null,null,null,2,null,null,null,null,null,null,2]
[null,1,null,null,null,null,null,null,1,null,null,null,null,null,null,1]
[]
[16,null,1,2,3,4,5,17,null,1,2,3,4,5,18,null,1,2,3,4,5]
[null,5,null,null,null,null,null,null,5,null,null,null,null,null,null,5]
[null,4,null,null,null,null,null,null,4,null,null,null,null,null,null,4]
[null,3,null,null,null,null,null,null,3,null,null,null,null,null,null,3]
[null,2,null,null,null,null,null,null,2,null,null,null,null,null,null,2]
[null,1,null,null,null,null,null,null,1,null,null,null,null,null,null,1]
[]
[19,null,1,2,3,4,5,20,null,1,2,3,4,5,21,null,1,2,3,4,5]
[null,5,null,null,null,null,null,null,5,null,null,null,null,null,null,5]
[null,4,null,null,null,null,null,null,4,null,null,null,null,null,null,4]
[null,3,null,null,null,null,null,null,3,null,null,null,null,null,null,3]
[null,2,null,null,null,null,null,null,2,null,null,null,null,null,null,2]
[null,1,null,null,null,null,null,null,1,null,null,null,null,null,null,1]
[]
[22,null,1,2,3,4,5,23,null,1,2,3,4,5,24,null,1,2,3,4,5]
[null,5,null,null,null,null,null,null,5,null,null,null,null,null,null,5]
[null,4,null,null,null,null,null,null,4,null,null,null,null,null,null,4]
[null,3,null,null,null,null,null,null,3,null,null,null,null,null,null,3]
[null,2,null,null,null,null,null,null,2,null,null,null,null,null,null,2]
[null,1,null,null,null,null,null,null,1,null,null,null,null,null,null,1]
[]
[25,null,1,2,3,4,5]
[null,5]
[null,4]
[null,3]
[null,2]
[null,1]